From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | albertca(at)jazzfree(dot)com, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: INSERT but no UPDATE or DELETE from windows |
Date: | 2003-07-09 20:39:36 |
Message-ID: | 200307092139.36703.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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?
--
Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Albert Cervera Areny | 2003-07-10 07:48:30 | Re: INSERT but no UPDATE or DELETE from windows |
Previous Message | J P | 2003-07-09 19:53:56 | Small but annoying Excel numeric import problem |