Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create Table in run time (urgent)
Message
 
 
À
10/10/2001 10:10:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00566398
Message ID:
00566400
Vues:
12
Carmen,

A field name can only start with letter or underscore '_'. It cannot start with digit. Add a letter or '_' prefix to the filed name.

>I want to create table in run time. for example
>
>
>I have a table called aSize
>
>Select lc_size from asize order by lc_size into cursor myCursor
>
>
>Select myCursor
>NoRec = Reccount()
>
>NoCnt = 0
>Do whil !Eof() and NoCnt < NoRec
>
> NoCnt = NoCnt + 1
>If NoCnt = 1
> Create Table myTable (code c(20),&nSize n(2))
>else
> Alter Table Add column &nSize
>Endi
>Select MyCursor
>skip
>Endd
>
>If this code success, the table's field will be looked like
>
> <---Size -->
> code,10,20,25,30
>
>
>so that i can calculate how many sales are they make on particular size
>
>But This Coding give me a syntax error, But it work on version 3.0 not on version 6.0
>
>
>
>Why?. Sorry for my english
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform