Issue with editing objects and QuoteNames
Posted: 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:
The error returned is:
Not found field corresponding parameter "PERSON"
Thanks for any help!
-Mark Ford
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;
Not found field corresponding parameter "PERSON"
Thanks for any help!
-Mark Ford