Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table in run time (urgent)
Message
 
 
To
10/10/2001 10:10:19
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00566398
Message ID:
00566400
Views:
10
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform