Fastreport4 + Postgresql
Hello
I'd like to use PostgreSQL database with my FR4. In Delphi programs i use Zeos components. Is there any way make them working with FR4 DataBands ?
Thank You in advance
Jacek Herold
I'd like to use PostgreSQL database with my FR4. In Delphi programs i use Zeos components. Is there any way make them working with FR4 DataBands ?
Thank You in advance
Jacek Herold
Comments
Thank You very much for Your answer - my IDE missed the TfrxDBDataset now i have it [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> But tell me please how to assign TfrxDBDataset with DataBand? Sorry for stupid question but i'm completely stuck. Tahnk You in advance Jacek Herold[/img]
Hi,..I use FR4,ZeosDBO 6.6.3 and PostgreSQL 8.4 too, I can do it in two ways :
1. using ADO/ODBC help...especially in your reporting only..not in your whole program/procedure due ADOComponents are
always supported by FR.
Using this way you have flexibility in report designing.. because you have not to connect your dataset from your code..
it's done internally using ADOTable/ADOQuery and you can build your query using ADOQuery at design time too...
but you must aware that you use two connection in this way...first is ZeosDBO for your general processes and ADO/ODBC
only for your reporting processes. It needs you to create DSN for ODBC first in your system. If you need only single Connection
you may not use ZeosDBO at all.
If you need to send params to your ADOQuery or to Your reporting object you must create variable inside your
report and assign value from your code...I hope this help...
2. using frxDBDataset..I success using this way...you can read my post as reply to Che Question with title
"assigning report dataset at runtime" ...You just need single Zeos ZDBconnection...no ODBC
sorry.. my poor english
Regards