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!! :)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only