Issue with editing objects and QuoteNames

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MarkF
Posts: 211
Joined: Thu 02 Mar 2006 14:55

Issue with editing objects and QuoteNames

Post by MarkF » Thu 07 Feb 2008 16:03

Hi Folks!

It appears that if Query.Options.QuoteNames is true that editing fails. You can test this by just changing the odac object demo to have QuoteNames set to true or use the following example:

Code: Select all

    OQuery.Session := OSession;

    OQuery.Options.QuoteNames := True;
    OQuery.SQL.Text := 'select rowid, oe.* from odac_emp oe';
    OQuery.Open();

    OQuery.Append;
    OQuery.FieldByName('PERSON.NAME').AsWideString := 'Ford, Mark';
    OQuery.Post;
The error returned is:
Not found field corresponding parameter "PERSON"

Thanks for any help!

-Mark Ford

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 08 Feb 2008 12:56

We have fixed this problem. The fix will be included in the next build of ODAC.

Post Reply