ODBC SQLSetPos Delete problem

Поиск
Список
Период
Сортировка
От Lothar Behrens
Тема ODBC SQLSetPos Delete problem
Дата
Msg-id 200409232110.i8NL9vJ18090@jedi.behrens.de
обсуждение исходный текст
Список 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.behrens@gmx.de
Rosmarinstr 3     | My public project:
40235 Düsseldorf  |  http://sourceforge.net/projects/lbdmf
                  |  -> Need comments, please visit :-)


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Shachar Shemesh
Дата:
Сообщение: Re: OIDS column required with ODBC ?
Следующее
От: Andreas
Дата:
Сообщение: concurrency with adodb & ms-access