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--