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.