Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Pass Through
Message
 
À
10/08/2000 20:28:24
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00403735
Message ID:
00403955
Vues:
17
>The UpdatableFieldList property seems to have a limit as to how long the string can be. How can I work around this. I have tried two UpdatableFieldList lines of code but it only uses the last one. Please help.

Steven,

I have no idea if this will work. However, according to MS KB article Q163800 on how to create an SQL Command greater than 255 characters, it's worth a shot. Basically, the idea in KB article is rather than passing one very long string as a parameter, use the concatenation opertor in the parameter list to pass individual portions of the string. If I'm not explaining this very well, consider the follow:
* lcfieldlist is a field list greater than 255 characters
= CURSORSETPROP("UpdateableFieldList", lcfieldlist) && Fails
* Try instead where lcfld1, lcfld2, lcfld3 are correctly
* formatted strings comprising portions of the list (ie lcfld1 = "field1,",
* lcfld2 = "field2," lcfld3 = "field3")
=  CURSORSETPROP("UpdateableFieldList", lcfld1 + lcfld2 + lcfld3)
Be warned this is a pure SWAG and therefore might not work in this scenario.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform