Re: Who can help with ODBC

Posted in 1999

Noel Griffin — Thu, 30 Dec 1999 22:03:31 -0000 — source: Informix-list mailing list archive (1991-1998)

We have used the InterSolv 3.11 driver for some time now and it works well. However it does not work properly via ADO, particullarly with DECIMAL data types. Intersolv posted a patch to the 3.11 driver on their web site about a year ago. If you use this it should be fine with ADO also. NOEL GRIFFIN Ireland Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> wrote in message news:83so5u$l9a$2@news02.btx.dtag.de... > Thank you for your help, Ilia. > > Yes it seems to be a syntax error. But it implies another question: > We deed the same with the Intersolv 3.11 ODBC driver and at > this point we received no error. Why does the Intersolv driver accept > the syntax and Informix ODBC 3.30/3.31 does not? > > Regards, > Reinhard > > Ilia Perminov <ilia@jet.msk.su> schrieb in im Newsbeitrag: hun7li7fjnh.fsf@goliath.jet.msk.su... > > "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> writes: > > > > ..... > > > We would be very happy if somebody could give us answers to following > > > questions: > > > > > > - What can we do with following errors (Informix ODBC 3.30 and 3.31): > > > > > > CaMain d9:122 ENTER SQLPrepare > > > HSTMT 0x019d3670 > > > UCHAR * 0x0012e120 [ -3] > > > "SELECT * FROM TRSYSTEM WHERE HERSTELLERSYSTEM = ? > > > FOR UPDATE OF herstellersystem ORDER BY herstellersystem\\ 0" > > > SDWORD -3 > > ...... > > > Is this a known bug? Can somebody report this to Informix. > > > > Hello, > > > > This is not a bug. You query is incorrect, because "ORDER BY" can't be used > > with "FOR UPDATE". "Informix Guide to SQL Syntax" says: > > > > Syntax That is Incompatible with the FOR UPDATE Clause > > A SELECT statement that uses a FOR UPDATE clause must conform to the > > following restrictions: > > - The statement can select data from only one table. > > - The statement cannot include any aggregate functions. > > - The statement cannot include any of the following clauses or > > keywords: DISTINCT, FOR READ ONLY, GROUP BY, INTO TEMP, INTO > > EXTERNAL, ORDER BY, UNION, or UNIQUE. > > > > Ilia > >