Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorSetProp
Message
From
19/12/2005 09:11:03
 
 
To
19/12/2005 09:07:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01079139
Message ID:
01079156
Views:
25
>Hi
>
>Unfortunately that won't work as I'm actually building the code dynamically, for example:
>
>lcCommand = "=CursorSetProp('UpdateNameList', '" + lcFieldList1 + "','" + lcParam1 + "')"
>&lcCommand
>
>If lcFieldList1 had 20 fields in it, which is actually quite conservative, the string lcCommand would exceed the 255 characters limit. I don't want to hard code the field list within the cursorsetprop as that'd mean I'd have to modify the statement each and every time that table structure is modified.
>
>Regards
=CursorSetProp('UpdateNameList',m.lcFieldList1 + ',' + m.lcParam1)
Previous
Reply
Map
View

Click here to load this message in the networking platform