Postgres Pro
Downloads
Home   >   mailing lists

Thread: [ODBC] Problem with ODBC v.10

[ODBC] Problem with ODBC v.10

From
Real Vision
Date:
Hello,

We use msaccess that connects to postgresql database with your ODBC driver

With the new version 10.0, something does not work anymore :

When we create a new record in a table with the dao method tb.addnew

Then we want to get the Autonumber generated, we used to add  tb.update and  tb.Bookmark=tb.LastModified  and then we were able to get the tb!MyAutoNumberField value

Now this does not wok anymore and we get   The record is deleted

(note that with MSAccess database we can get the autonumber before the tb.update)


I saw that you have changed things with Identity...  Maybe you broke something...

Regards,

Dan


Re: [ODBC] Problem with ODBC v.10

From
"Inoue, Hiroshi"
Date:
Hi,

On 2017/11/08 23:19, Real Vision wrote:
> Hello,
>
> We use msaccess that connects to postgresql database with your ODBC driver
>
> With the new version 10.0, something does not work anymore :
>
> When we create a new record in a table with the dao method tb.addnew

Unfortunately I have not used DAO for more than 10 years.
Could you show me an example?

>
> Then we want to get the Autonumber generated, we used to add  
> tb.update and  tb.Bookmark=tb.LastModified  and then we were able to 
> get the tb!MyAutoNumberField value
>
> Now this does not wok anymore and we get   The record is deleted
>
> (note that with MSAccess database we can get the autonumber before the 
> tb.update)
>
>
> I saw that you have changed things with Identity...  Maybe you broke 
> something...
>
> Regards,
>
> Dan


-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc