Still problems with pgODBC - Mailing list pgsql-odbc

From Lothar Behrens
Subject Still problems with pgODBC
Date
Msg-id 200410231113.i9NBD5C28887@jedi.behrens.de
Whole thread Raw
List pgsql-odbc
Hi,

I have still problems with my application using pgODBC driver.

I am mainly using Windows 2000, Openwatcom 1.2 and the official
Cyborg 7.3.200 version of the ODBC driver.

I can delete a row and after doing that I am able to move to first or
last row. But if I try to move next, I get this log messages amd my
app crashes - possibly due to the 'SC_pos_reload_needed'.

Why and how can I avoid this problem ?

I tried to do a SQL_REFRESH, but this doesn't help.

I have tested my application against MS SQL and Sybase database. It
works, but it might be still a bug in my code - I think.

(Possibly the proper handling of the above 'SC_pos_reload_needed'
message)

Thanks

Lothar


[872]DEFAULT: len = 20, ptr = '12345               '
[872]    SQL_C_CHAR, default: len = 20, cbValueMax = 21,
rgbValueBindRow = '12345               '
[872]copy_and_convert: retval = 0
[872][SQLExtendedFetch][872]PGAPI_ExtendedFetch: stmt=15799552
[872]SQL_FETCH_NEXT: num_tuples=4, currtuple=1
[872]SC_pos_reload_needed
[872]PGAPI_ExtendedFetch: new currTuple = 1
[872]manual_result = 0, use_declarefetch = 0
[872]type = -858993460 and valuepointer here (line: 871) is 00000000
[872]**** SC_fetch: manual_result
[872]type = -858993460 and valuepointer here (line: 909) is 00000000
[872]manual_result = 0, use_declarefetch = 0
[872]type = -858993460 and valuepointer here (line: 871) is 00000000
[872]**** SC_fetch: manual_result
[872]type = -858993460 and valuepointer here (line: 909) is 00000000
[872]type = -858993460 and valuepointer here (line: 951) is 00000000
[872]fetch: cols=9, lf=0, opts = 15799640, opts->bindings = 15831744,
buffer[] = 15667784
[872]type = -858993460 and valuepointer here (line: 958) is 00000000
[872]type = 1042 and valuepointer here (line: 967) is 00000000
[872]copy_and_convert: field_type = 1042, fctype = 99, value = '

---- My home: www.lollisoft.de -----------------------------
Lothar Behrens    | Independent:       lothar.behrens@gmx.de
Rosmarinstr 3     | My public project:
40235 Düsseldorf  |  http://sourceforge.net/projects/lbdmf
                  |  -> Need comments, please visit :-)


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Snapshot release 08.00.0002 uploaded
Next
From: "Joost Kraaijeveld"
Date:
Subject: Does SQLFetch get all the data from the database?