Re: Informix and Delphi

In article <4jpo8t$kd1@geraldo.cc.utexas.edu>, jfalck@pobox.com (JAY FALCK) wrote: >I asked this question about a month ago and then lost access to the >newsgroup. Please forgive my asking again. If you ever need to look-up something in comp.database.informix an easy option is to use the search engine at www.iiug.org. >I need to be able to execute the following in a Delphi application >against my Informix database on a Unix box. I'm using WFW 3.11, >Delphi 1.02, Intersolv ODBC drivers, INET version 5 and Informix >Standard Engine 5. > >update table set column = column + 1 > where some condition>if no rows updated, then insert new row with specified values. We've built a simple stored procedure which just returns the appropriate SQLCA element via a call to DBINFO, then I have a little Delphi routine (called "updated") that executes the stored procedure and returns the value. Not as nice as an imbedded SQLCA record, but not bad either. Cheers, Kerry S ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/