Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group