Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format

Links

XODOX
Impressum

#1: Recordset not updatable

Posted on 2004-03-11 22:53:01 by omega

Hi,=20

after trying around for two evenings and browsing the usenet in vain,
I hope that someone reading this can help me with the following
problem:

I use postgresql 7.3.4 on a linux box and the postgresql ODBC driver
version 7.3.200 on a windows 2k box.

My program is written in Delphi 6 PE with a self-made derivative of
KADAOPE for database access using DAO. Reading and writing Access
databases using DAO recordsets with Jet workspace works fine. Reading
Postgres Databases using ODBC workspace works fine too. The postgresql
ODBC driver options are the default values.

Problem: I cannot get an updatable recordset.

CursorDriver is dbUseDefaultCursor.
recordset is opened with dbOpenDynaset
Example: DAORecordSet:=3D
FDAODatabase.CoreDatabase.OpenRecordset("SELECT * FROM mytable where
id1=3D4711", dbOpenDynaset).
mytable has a compound primary key (id1,id2).

DAORecordSet.Updatable is FALSE, and, consequently, DAORecordSet.Edit
fails with a write protection error.

I then tried and changed the parameters from dbOopenDynaset to
dbOpenDynamic, 0, dbOptimisticValue. But this makes
DAORecordSet.MoveLast fail with "Illegal operation" while the
recordset still is not updatable.

After updating the driver to version 7.3.208 from
http://www.geocities.jp/inocchichichi/psqlodbc/, MoveLast fails with
an Access violation error at ... in psqlodbc.dll.

Is there anybody out there who got psqlodbc to open updatable
recordsets via DAO? Any hints?

Many thanks in advance!
Boris

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Report this message