Search Postgresql Archives

Re: PostGreSQL to Access Updatable recordset

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux