Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is best way to go around 255 schema length in CA?
Message
 
À
21/01/2004 13:37:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00868864
Message ID:
00869324
Vues:
13
Aleksey,

Here is on way, I found to go around the 255 limit.

1) Start CA builder and build Select command. Add as many fields you like.
2) Build Schema, lets say that the length is 1000
3) Copy (Ctrl + C) the schema
4) Delete all from the schem except the first field definiton (f.ex. C1 C(10))
5) Press ok to save and exit (now you have only one field in your DE.Cursor
6) Use command window to define unique public variable (f.ex. _Abc987)
7) Store clipboard value (Ctrl+V) to that variable
8) Start CA builder, replace the value of Schema editbox with &_Abc987
9) Press OK to save and exit

Now the cursor in DE has all the field you defined in Select command window

The drawback is that when you next time open the form in design time you have to check the existense of that varialbe and that it has correct value. How ever it can be done easily with single prg.
PUBLIC _Abc987
_Abc987=;
"C1 C(10), B1 C(10), D1 C(10), E1 C(10), N1 I, "+ ;
"C2 C(10), B2 C(10), D2 C(10), E2 C(10), N2 I, "+ ;
"C3 C(10), B3 C(10), D3 C(10), E3 C(10), N3 I, "+ ;
"C4 C(10), B4 C(10), D4 C(10), E4 C(10), N4 I, "+ ;
"C5 C(10), B5 C(10), D5 C(10), E5 C(10), N5 I, "+ ;
"C6 C(10), B6 C(10), D6 C(10), E6 C(10), N6 I, "+ ;
"C7 C(10), B7 C(10), D7 C(10), E7 C(10), N7 I, "+ ;
"C8 C(10), B8 C(10), D8 C(10), E8 C(10), N8 I, "+ ;
"C9 C(10), B9 C(10), D9 C(10), E9 C(10), N9 I, "  + ;
"C10 C(10), B10 C(10), D10 C(10), E10 C(10), N10 I"
AT
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform