Desmond Coertzen wrote:
I tried TPQConnection in a production environment on a server-side deamon, and bytea was the first missing data type that haunted me. The "encode" postgres function will save you here: Encode your bytea field
I can't remember, but I think bytea (I call it blob) work fine for me, but I'll have to double check to be 100% sure.
to hex, then run a hextobin afterwards. (Sorry if you use dbAware components in this case). Some other field types were missing as well, I
I do not use DB-aware components in our applications. I use "mediator views" also know as Model-GUI-Mediator. The the following URL for an article on it.
http://opensoft.homeip.net/articles/
of TDataSet, but, it worked for everything I needed in those daemons, it is lightweight and stable. !!/No support for parameters and prepared statements/!!
I have had some "prepare statement" issues with SqlDB+PostgreSQL as well. I still need to investigate this further. In the mean time, I disable all "prepare" calls in my application for now.
I'm still a novice pascal programmer. If you are interested in my code, I can publish somewhere and send you a url.
Are we allowed to merge some of your changes back into the SqlDB code? If so, yes please do post a url.
Regards, - Graeme - -- fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://opensoft.homeip.net/fpgui/ _______________________________________________ fpc-devel maillist - fpc-devel@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-devel
