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