Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement