>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')
=cursorsetprop('updatenamelist';
,'Login_Name SQLTable.Login_Name';
+',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