Postgres Pro
Downloads
Home   >   mailing lists

Re: PostGreSQL to Access Updatable recordset - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PostGreSQL to Access Updatable recordset
Date
Msg-id 20041113215908.GB12499@dcc.uchile.cl
Whole thread Raw
In response to PostGreSQL to Access Updatable recordset  ("Sim Zacks" <sim@nospam.com>)
List pgsql-general
Tree view 
On Tue, Nov 09, 2004 at 01:53:18PM +0200, Sim Zacks wrote:
> I have a postgresql backend with an access front end and I am trying to
> redefine the recordset of the form to use an ADO recordset. The problem is
> that the CursorType always changes to AdOpenStatic, even if I choose
> adOpenDynamic. If anyone has any thoughts, please let me know. The form
> works great for viewing, but I cannot update or insert any new records.

Postgres does not support updatable cursors yet.  Maybe that's why the ADO
driver changes the cursor type from AdOpenDynamic to AdOpenStatic.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: The classic "NEW used in query that is not in a rule" problem again
Next
From: "Gregory S. Williamson"
Date:
Subject: Mysterious Death of postmaster (-9)