I am converting some ADO code to SDAC and have run into
QData.Properties['Update Criteria'].Value := adCriteriaKey;
What is the TMSQuery equivalent?
TADOQuery and Update Criteria
-
AndreyZ
Re: TADOQuery and Update Criteria
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.