ADO Server Cursors and OID

From: "Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ADO Server Cursors and OID
Date: 2003-09-12 15:44:53
Message-ID: 3F61E9F5.C2ECA09F@us.michelin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I have created a table with a serial ID (sequenced) key_id field which
is also the PRIMARY KEY using pgAdmin. I've looked at the create table
statement. It has a WITHOUT OIDS clause. Table works fine, but I seem to
be unable to make ADO server side cursors. (VB).

Is there a key to enabling server side cursors.
I can link the table in Access and browse it and change field values. It
gives the impression of server side cursor, although I do not know if
that is what it is really doing. The DAO engine->pgODBC may be (must be)
behaving differently than my ADO code->pgODBC.

I know I can work around with client side cursors for selects, and use
INSERT,UPDATE executable queries. But with inserts/updates that have
many fields or needing to escape (/') text fields that might contain
quotes, the coding can get a little hairy compared to updating a cursor
field.

***************************************************************
This email and all files transmitted with it are
confidential and intended solely for the use of the
individual or entity to whom they are addressed. If you
are receiving this email in error please notify the
system manager.

This footnote also confirms that this message
has been swept for the presence of computer viruses.
***************************************************************

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrew Ayers 2003-09-12 16:21:35 Re: DSN-less connection...
Previous Message Tom Lane 2003-09-12 14:24:05 Re: Limiting the number of records in Execute Query