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: | 200409232110.i8NL9vJ18090@jedi.behrens.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
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 ?
Thanks
Lothar
---- My home: www.lollisoft.de -----------------------------
Lothar Behrens | Independent: lothar(dot)behrens(at)gmx(dot)de
Rosmarinstr 3 | My public project:
40235 Düsseldorf | http://sourceforge.net/projects/lbdmf
| -> Need comments, please visit :-)
From | Date | Subject | |
---|---|---|---|
Next Message | Melanie Bergeron | 2004-09-24 14:57:04 | odbc with PostgreSQL 8.0 & Delphi |
Previous Message | Solo Vision | 2004-09-23 04:14:33 | Hello |