Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass Through
Message
 
To
10/08/2000 20:28:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00403735
Message ID:
00403955
Views:
16
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform