| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Sim Zacks <sim(at)nospam(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostGreSQL to Access Updatable recordset |
| Date: | 2004-11-13 21:59:08 |
| Message-ID: | 20041113215908.GB12499@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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[(at)]dcc(dot)uchile(dot)cl>)
"Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera Munoz | 2004-11-13 22:00:27 | Re: Documentation of server configuration |
| Previous Message | Alvaro Herrera | 2004-11-13 21:55:36 | Re: The classic "NEW used in query that is not in a rule" problem again |