Extract Firebird Database with Predefined Layout

Question

I need to extract some information from the database, with a predefined layout and launch into a file. TXT

Example:

1 to 10 digit size code; name size from 1 to 20 digits; date sale size of dd/mm/yyyy; size value from 1 to 15 digits;

Then in case the exit would have to be like this:

And so on and so forth.

I looked for how to do it and there are many ways to both create an application and using application that create reports.

I wanted to know a more agile way, and I can deliver so that the client can make future reports without having to contact me.

Answer 1

http://www.ibexpert.net/ibe/index.php?n=Doc.SystemObjects

Broad question , but based on the metadata tables it is possible to create applications that assemble queries and based on these queries user-assembled reports, it is not a trivial programming but also not "rocket engineering". Maybe there are even codes available on the Web.

These reports could be in txt to facilitate, a simple way of doing.

I hope I’ve helped.

Answer 2

I used the same Crystal Reports tool to extract this information to a TXT file, but had to model the data as the Tax Software requires the provision of information.

Anyone interested can get a trial version of Crystal Reports on the site http://www.crystalreports.com/