No Current Record - Mailing list pgsql-odbc

From Simon Dobie
Subject No Current Record
Date
Msg-id 4095E604.70301@auditbureau.org.au
Whole thread Raw
List pgsql-odbc
Hi,

I saw a thread with the exacxt same error i get but no solution.

I have a postgres DB backend with a table that has 1200 records.  I am
using Access to interface with this DB because the forms are very easy
to build. unfortunatly, any data in the table that has been put in there
via Access (i wrote an import routine to insert the records.)  will
display in my form, but any effor to edit it tells me "No Current Record".

its pretty pathetic that i am able to input the data but then it gives
me errors when editing the record. *glares at microsoft*

the table has a primary key which is type 'numeric' according to
pgAdminIII. Access detects it as a decimal for some reason. also, the
field is set to be a auto increment in postgres via a function (done via
pgadmin) but that doesnt seem to work. and yes, the form is set to
dynaset type :)

does anyone have a solution for this problem before i pull all my hair out?
%simon



pgsql-odbc by date:

Previous
From: Thomas Løjmann Jørgensen
Date:
Subject: unsubscribe
Next
From: Martin Pitt
Date:
Subject: Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)