I’ve a customized solution which works like a charm in NF 2.60 D Native but give me a bunch of error messages under SQL. The error thrown all the time is Another user has modified the record for this TableX after you have retrieved it from the data This error is Generated when the debugger reach the line TableX.Modify(TRUE); I think they’re some guidelines for modifying records under SQL. Does anyone have those handy ? tarek_demiati@ureach.com Edited by - Tarek Demiati on 2001 Apr 24 13:19:20
From the Upgrade-Manual on the Product-CD ----------------------------------------- If you receive error messages informing you that a record has been modified by another user, even though you are the only user currently using the system, you have version control conflicts. These problems occur because the SQL Server Option for Navision Financials 2.60 has stricter version control than previous versions of Navision Financials. Any attempt to modify or delete a record will fail if thetimestamp on the version of the record that you have read is different from the timestamp on the actual record stored in the database. The following tables contain examples of the old incorrect code and the new correct code that must be used: Old Code -------- Rec.GET; NewRec.GET; NewRec. := ’New’; NewRec.MODIFY; → INSERT A NEW LINE: Rec.GET; Rec… := ’Old’; Rec.MODIFY; Old Code -------- Rec. := 1; → INSERT A NEW LINE: IF Rec.FIND THEN Rec.INIT; Rec. := ’New’; IF NOT Rec.INSERT THEN Rec.MODIFY;