ADO Error: Row Cannot Be Located for Updating

[topcat01]

I have looked in the list archives and searched the internet for a solution and keep coming to this code:

DataSet.Recordset.Properties['Update Criteria'].Value := AdCriteriaKey;

When I enter the code I get 'AdCriteriaKey' as unidentified...

How can this be called sucessfully in D7?

Thanks.

 

[DjangMan]

Typically this error means that your query is constructed in a way that the database engine can't update the record - usually because of a join. Can you show us your query?

 

[topcat01]

Thanks for the reply.

Having re-read my post I forgot to describe the setup and circumstances, not very helpful, sorry about that.

I'm building with D7 and ADO with connection to SQL Server 2005. The main form of the application is using typical dbEdit and dbNavigation controls to add and edit records.

I have three machines, one setup as sql server and two computers running instances of the database application I'm developing.

When I run a single instance of my program everything appears to work fine, it is when I am adding/deleting records when more than one instance of the program is running and accessing and manipulating the db at the same time.

I can understand why I am getting the error but do not know how to fix it. How can I make sure, in the above example, that both applications remain 'syncd' so if a record is changed/added using one app another instance of the app will identify the change automatically? I have hidden the refresh button from the DBNavigiation since I cannot expect the user to remember to refresh the data after each use.

Please let me know if you still need the query information or any other information for that matter.

Thanks again