Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid RowSource(SQL) greater than 255 chars?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00116704
Message ID:
00116948
Views:
18
Petras,

I'm sorry I led you down the wrong path. I assumed any length string could be put there via real code without the limits imposed on the property sheet values. But you are quite right this bug clips the string at 256 characters.

I've never run into the limit because I've added a SQL() method to my cbo class where I put the SELECT to populate the maItems array which is the RowSource I mainly use for the cbo control.

>Thanks for the replies, I think Jim's suggestion is probably worth a try. No matter where and how you construct the "SELECT" string, you cannot put more than 255 chars in the property "RowSource". At the moment I am using a two-stage SELECT, the first is a SELECT statement into a temporary cursor and the second one is a "SELECT * " ,with an additional bunch of conditions, from the temporary cursor into the grid's RowSource.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform