TADOQuery and Update Criteria

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
GNiessen
Posts: 28
Joined: Wed 18 Jan 2012 20:15

TADOQuery and Update Criteria

Post by GNiessen » Tue 05 Mar 2013 15:38

I am converting some ADO code to SDAC and have run into

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

What is the TMSQuery equivalent?

AndreyZ

Re: TADOQuery and Update Criteria

Post by AndreyZ » Wed 06 Mar 2013 10:24

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.

Post Reply