Hi Ken...

OK.... I have this problem solved...

The trick is to add the timestamp field name to the keyfieldlist property of the cursor:

CursorSetProp( 'KeyFieldList',"id,lastedited","cCustomer")


In my sample, lastedited is the timestamp field.

Here is the sample code to setup the cursor:

lnHandle = sqlconnect("test","sa","")
=sqlexec(lnHandle,"exec getcustomers","cCustomer")
CursorSetProp('Tables',"customers","cCustomer")
CursorSetProp('UpdatableFieldList',"id,name,lastedited","ccustomer")
CursorSetProp('UpdateNameList',"id customers.id,name customers.name lastedited customers.lastedited","cCustomer")
CursorSetProp( 'KeyFieldList',"id,lastedited","cCustomer")
CursorSetProp( 'UpdateType', 1,"cCustomer")
CursorSetProp( 'WhereType', 4,"cCustomer")
CursorSetProp( 'FetchMemo', .T.,"cCustomer")
CursorSetProp( 'SendUpdates', .T.,"cCustomer")
CursorSetProp( 'UseMemoSize', 255,"cCustomer")
CursorSetProp( 'FetchSize', 100,"cCustomer")
CursorSetProp( 'MaxRecords', -1,"cCustomer")
CursorSetProp( 'Tables', 'dbo.customers',"cCustomer")
CursorSetProp( 'Prepared', .F.,"cCustomer")
CursorSetProp( 'CompareMemo', .T.,"cCustomer")
CursorSetProp( 'FetchAsNeeded', .F.,"cCustomer")
CursorSetProp( 'FetchSize', 100,"cCustomer")
CursorSetProp( 'BatchUpdateCount', 1,"cCustomer")
CursorSetProp('Tables',"customers","cCustomer")


Let me know how things work out!! :)