Thread: Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database
From
"Hollysugar Webmaster"
Date:
Hiroshi,
Thank you very much for replying. We did finally determine that the problem with the update was that the oid column was a user defined column. The vendor for our mobile database altered their application so it no longer needed to utilize an oid column and we were successfully able to use sql_update and sql_delete. We are still having problems with sql_add. I have pasted a snippet of the code from the psqlodbc mylog below. Thank you in advance for any help you can offer on this.
Julie
<snippet>
[3148]pcrow=1
[3148][SQLSetPos][3148]PGAPI_SetPos fOption=4 irow=2 lock=0 currt=1
[3148]STATEMENT ERROR: func=PGAPI_SetPos, desc='', errnum=21, errmsg='Row value out of range'
[3148]CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=1[3148]**** PGAPI_StmtError: hstmt=19137600 <2000>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148] szSqlState = 'S1107',len=22, szError='Row value out of range'
[3148]PGAPI_GetDiagRec exiting 0
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=2[3148]**** PGAPI_StmtError: hstmt=19137600 <2000>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148]PGAPI_GetDiagRec exiting 100
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=1[3148]**** PGAPI_StmtError: hstmt=19137600 <512>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148] szSqlState = 'S1107',len=22, szError='Row value out of range'
[3148]PGAPI_GetDiagRec exiting 0
</snippet>
----- Original Message -----
From: Hiroshi Inoue
To: SweetBeet.com Webmaster
Cc: pgsql-odbc@postgresql.org ; Dave Page
Sent: Friday, April 11, 2003 3:27 AM
Subject: RE: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Sorry for the late answer.
How did you create the "contract_test" table ?
OID seems to be a user column in contract_test not a system column.
regards,
Hiroshi Inoue
-----Original Message-----
From: SweetBeet.com Webmaster [mailto:webmaster@agterra.com]
Sent: Wednesday, April 09, 2003 4:46 AM
To: Dave Page
Cc: pgsql-odbc@postgresql.org; Hiroshi Inoue
Subject: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Dave,
We tried both the snapshot of the psqlodbc driver and the snapshot of the psqlodbc30 driver. We were not able to get either to work. I looked through the logs and when I searched for "error" I did find new error messages but I am not sure what they mean. I have attached all the logs for both drivers. I truncated the mylogs to reduce their size, let me know if you need to see the full log
Julie
Thank you very much for replying. We did finally determine that the problem with the update was that the oid column was a user defined column. The vendor for our mobile database altered their application so it no longer needed to utilize an oid column and we were successfully able to use sql_update and sql_delete. We are still having problems with sql_add. I have pasted a snippet of the code from the psqlodbc mylog below. Thank you in advance for any help you can offer on this.
Julie
<snippet>
[3148]pcrow=1
[3148][SQLSetPos][3148]PGAPI_SetPos fOption=4 irow=2 lock=0 currt=1
[3148]STATEMENT ERROR: func=PGAPI_SetPos, desc='', errnum=21, errmsg='Row value out of range'
[3148]CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=1[3148]**** PGAPI_StmtError: hstmt=19137600 <2000>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148] szSqlState = 'S1107',len=22, szError='Row value out of range'
[3148]PGAPI_GetDiagRec exiting 0
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=2[3148]**** PGAPI_StmtError: hstmt=19137600 <2000>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148]PGAPI_GetDiagRec exiting 100
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=1[3148]**** PGAPI_StmtError: hstmt=19137600 <512>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148] szSqlState = 'S1107',len=22, szError='Row value out of range'
[3148]PGAPI_GetDiagRec exiting 0
</snippet>
----- Original Message -----
From: Hiroshi Inoue
To: SweetBeet.com Webmaster
Cc: pgsql-odbc@postgresql.org ; Dave Page
Sent: Friday, April 11, 2003 3:27 AM
Subject: RE: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Sorry for the late answer.
How did you create the "contract_test" table ?
OID seems to be a user column in contract_test not a system column.
regards,
Hiroshi Inoue
-----Original Message-----
From: SweetBeet.com Webmaster [mailto:webmaster@agterra.com]
Sent: Wednesday, April 09, 2003 4:46 AM
To: Dave Page
Cc: pgsql-odbc@postgresql.org; Hiroshi Inoue
Subject: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Dave,
We tried both the snapshot of the psqlodbc driver and the snapshot of the psqlodbc30 driver. We were not able to get either to work. I looked through the logs and when I searched for "error" I did find new error messages but I am not sure what they mean. I have attached all the logs for both drivers. I truncated the mylogs to reduce their size, let me know if you need to see the full log
Julie