Hi

I'm using the Cursorsetprop('UpdateNameList') property to inform SQL which fields in my local table I wish to update in the parent SQL table.

This works fine:

=cursorsetprop('updatenamelist', 'Login_Name SQLTable.Login_Name', 'LocalTable')

This doesn't work fine:

=cursorsetprop('updatenamelist', 'Login_Name SQLTable.Login_Name', 'LocalTable')
=cursorsetprop('updatenamelist', 'Login_User SQLTable.Login_User', 'LocalTable')

Only the first field is update, i.e. the Login_Name field. I have to use more than one cursorsetprop as the list of fields is greater than the 255 characters allowed in a string. I'm building the field list on the fly as some tables could have 100 fields and I don't want to have to update the code manually each time the table structure changes.

Any ideas? Would I, for example, have to loop around each cursorsetprop and issue a tableupdate, rather than issuing one tableupdate below all of the cursorsetprop commands?

Regards