Hi

When I try the following code, it updates ALL records in the table with the same ID field value:

LPARAMETERS tcTable
LOCAL loRS, lnVal
tcTable = ALLTRIM(UPPER(tcTable))

*Get recordset
loRS = this.GetRecordSet("SELECT Id FROM NextId WHERE Table = '" + tcTable + "'", 3)

*Up ID
loRS.Fields("Id").Value = loRS.Fields("Id").Value +1
loRS.Update()
lnVal = loRS.Fields("Id").Value 
loRS.Close()

*Return next id
RETURN lnVal

The GetRecordSet() Method also sets up the LockType property with the 2nd parameter (3).

Any ideas on what I'm doing wrong here?

Thanks
Kev