Problem in Archive Document

sunmorningindia

Hi,

Recently the client database is migrated to SQL Server 2005, now we have problem in Archive document. The archive function is working proper in Navision Database. This functionality is customize here. The error message is :---
Another user has modified the record for this sales header after you retrieve it from the database. update your window and start the activity again.

Is this problem related to the difference in "SQL is not version based.".

Manish Kr. Sinha

kine

Yes, it seems.

In most cases it is problem of wrongly coded things. In your customization is something like:

   MyRec.GET(RecNo);
   CallMyFunction(RecNo);
   MyRec.FIELDX := ValueY;
   MyRec.MODIFY;

If CallMyFunction will modify the same record, you will have this error called when MyRec.MODIFY is processed. This "nested" modification can be nested through more levels than 1...