Hi,

I'm connecting to Informix 7.31 UC3 on HP-Unix from Win 2k using client-sdk ver 2.80 TC1.

I'm trying to insert a record fom an VB application.

The insert statement is
"INSERT INTO
pdmcontracttraffic
(contracttrafficid,
contractid,
contractnum,
clientid,
clientname,
earliestflstart,
latestflend,
traffstatusid,
entrydate,
employeeid)
SELECT DISTINCT
0,
pdmcontract.contractid,
pdmcontract.contractnum,
pdmclientagency.clientagencyid,
pdmclientagency.name,
MIN(pdmlineitem.currentstart),
MAX(pdmlineitem.currentend),
11,
'2003-09-05 11:32:58',
1145
FROM
pdmcontract,
pdmclientagency,
pdmlineitem
WHERE
pdmlineitem.contractid = pdmcontract.contractid AND
pdmcontract.clientid = pdmclientagency.clientagencyid AND
pdmcontract.contractid in (620) AND
pdmcontract.contractid not in(select contractid from pdmcontracttraffic)
GROUP BY
pdmcontract.contractid,
pdmcontract.contractnum,
pdmclientagency.clientagencyid,
pdmclientagency.name"

I'm getting an error saying "[Informix][Informix ODBC Driver]General error.Syntax error".

But if I run the sql in dbaccess query utility on HP Unix, it works fine.

Can somebody resolve my issue??

Thanks in advance

I'm no expert, but have you tried seperating the two statements with a semicolon ';'

I suspect that dbaccess is clever enough to see you are running two seperate sql statements and do each one at a time, I think the ODBC api prepare funtions aren't that clever.

regards

Hi,

What odbc driver do you use? csdk version?
You can download the latest one from th eevaluate ibm/informix site.

Hi
I was using 2.80 TC1. I upgraded that to 2.81 TC1. It's working fine now.

Ok - this was a known issue.