Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid RowSource(SQL) greater than 255 chars?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00116704
Message ID:
00116948
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform