Update generate error

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Valgardur
Posts: 165
Joined: Tue 24 Nov 2009 19:33

Update generate error

Post by Valgardur » Thu 24 May 2012 13:46

Hi, when using SQL Generator in TOraQuery the generator ignores the key field defintion and sets the last field as key field (for update and delete).

PS. In SDAC a similar problem that just appeared in the latest version, although it is more chaotic..

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Update generate error

Post by AlexP » Fri 25 May 2012 07:47

hello,

Please, specify the exact versions of ODAC and SDAC you have, problems with SQL generator existed in versions ODAC 8.1.5 and SDAC 6.1.5, in the latest versions 8.1.6 and 6.1.6 correspondingly these problems are fixed.

Valgardur
Posts: 165
Joined: Tue 24 Nov 2009 19:33

Re: Update generate error

Post by Valgardur » Fri 25 May 2012 11:30

Thanks, my mistake, I thought I had the most recent version installed, perhaps confusing that the install executables have the same name...

But, seems to be working fine now.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Update generate error

Post by AlexP » Fri 25 May 2012 11:44

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

Post Reply