Lists: | pgsql-odbc |
---|
From: | Real Vision <realvision(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem with ODBC v.10 |
Date: | 2017-11-08 14:19:20 |
Message-ID: | CANpzAR=sfqMchxfJDRtgD+=rDY7xwCQmr9mWidkqH2CoqJVXjg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
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
From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Real Vision <realvision(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Problem with ODBC v.10 |
Date: | 2017-11-13 12:52:11 |
Message-ID: | 7b4e09de-c5eb-e35a-e291-2598f1ef03c0@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
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