No Current Record

From: Simon Dobie <simon(at)auditbureau(dot)org(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: No Current Record
Date: 2004-05-03 06:26:12
Message-ID: 4095E604.70301@auditbureau.org.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Martin Pitt 2004-05-04 14:03:57 Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)
Previous Message Thomas Løjmann Jørgensen 2004-05-03 05:58:31 unsubscribe