Skip site navigation (1) Skip section navigation (2)

ODBC SQLSetPos Delete problem

From: "Lothar Behrens" <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC SQLSetPos Delete problem
Date: 2004-09-23 19:40:23
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc

just another 'another' question :-)

How do I reopen a new statement with the possible cursor
position near a deleted row ?

This possibliy would avoid the crash.

Another way to avoid this crash is a 'fake' deletion of
the selected row - based on the primary key of the table.

Idea: For simple tables, collect their pk's (names) and
store it in a pk table. Then on each 'deletion' mark only
a - possibly prior altered table (deleted (true/false)) -
field and modify the where clause for the intented query.

Any suggestions ?



---- My home: -----------------------------
Lothar Behrens    | Independent:       lothar(dot)behrens(at)gmx(dot)de
Rosmarinstr 3     | My public project:
40235 Düsseldorf  |
                  |  -> Need comments, please visit :-)

pgsql-odbc by date

Next:From: Melanie BergeronDate: 2004-09-24 14:57:04
Subject: odbc with PostgreSQL 8.0 & Delphi
Previous:From: Solo VisionDate: 2004-09-23 04:14:33
Subject: Hello

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group