Re: INSERT but no UPDATE or DELETE from windows - Mailing list pgsql-odbc

From Albert Cervera Areny
Subject Re: INSERT but no UPDATE or DELETE from windows
Date
Msg-id 200307101023.44294.albertca@jazzfree.com
Whole thread Raw
In response to Re: INSERT but no UPDATE or DELETE from windows  (Richard Huxton <dev@archonet.com>)
List pgsql-odbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A Dimecres 09 Juliol 2003 22:39, Richard Huxton va escriure:
> On Wednesday 09 Jul 2003 2:25 pm, Albert Cervera Areny wrote:
> > Hi,
> >   I have Postgres 7.3.3 and ODBC driver 7.03.0100 and as the subject
> > says, I can INSERT but can't UPDATE nor DELETE. I can also create new
> > tables. The user has permision to do this as the psql \dp show the
> > correct privileges and lets me UPDATE without problems using the same
> > user as the ODBC driver.
> >
> >   I open the database as Dynaset (from VB and Visdata) but when I try to
> > UPDATE or .Edit a record it says something like 'should use an updatable
> > query' (translated from spanish).
> >
> >   The odbc connection is not, of course, read only.
>
> Can you give us the options ticked/not in the odbc driver settings and the
> options used when creating the cursor?

Now, I've been able to us UPDATE using the dbSQLPassthrough option parameter,
but can't update using a recordset. With Openrecordset, the dbSQLPassthrough
parameter is only valid for dbOpensnapshot and I can't update using any of
dbOpenDynaset, dbOpenDynamic, dbOpenTable either.

Any suggestions? Thanks for your help.

PS: I use the simple PostgreSQL driver, not the UTF beta one.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/DSKLTK7ZP4pDOHcRAgMcAJ9uWpzmDwafNfYPX4gUI4x/S7rJTACgjXnK
7jBroXNhK0bSswfQkK62EW4=
=7iCE
-----END PGP SIGNATURE-----

pgsql-odbc by date:

Previous
From: Marco Gaiarin
Date:
Subject: Re: This thing drive me crazy! ;(
Next
From: "J P"
Date:
Subject: Small but annoying Excel numeric import problem