Page 1 of 1

TADOQuery and Update Criteria

Posted: Tue 05 Mar 2013 15:38
by GNiessen
I am converting some ADO code to SDAC and have run into

QData.Properties['Update Criteria'].Value := adCriteriaKey;

What is the TMSQuery equivalent?

Re: TADOQuery and Update Criteria

Posted: Wed 06 Mar 2013 10:24
by AndreyZ
TMSQuery does not need such property. If a table has an IDENTITY field, TMSQuery uses it for updating. If a table does not have an IDENTITY field but has Primary Key, TMSQuery uses Primary Key fields for updating. If a table does not have an IDENTITY field and Primary Key, TMSQuery uses all fields for updating.