Sergey

It would appear that the problem lies with this piece of code:

=CursorSetProp('UpdateNameList', lcRemoteTableFields, lcParam1)

If I explicitly replace lcRemoteTableFields with, for example, 'User_Forename, User_Surname', then the cursor update works without problem, no matter which record is selected. The problem is caused by the length of the string lcRemoteTableFields, i.e. when it exceeds 255 characters. This doesn't explain why updates always work on the 1st record of the SQL, however it does explain why they weren't working on subsequent records.

##Update##

The text string, lcRemoteTableFields, cannot be greater than 255 characters, and you cannot build the command and execute using & either. However, you can do multiple:

=CursorSetProp('UpdateNameList', lcRemoteTableFields1, lcParam1)
=CursorSetProp('UpdateNameList', lcRemoteTableFields2, lcParam1)

Where lcRemoteTableFields1 and 2 are less than 255 characters each.

Regards

Derek