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 (AT) gmx (DOT) de
Rosmarinstr 3 | My public project:
40235 Düsseldorf | http://sourceforge.net/projects/lbdmf

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend