Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
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