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