Carmen,
See corrections in bold below
>
>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
<b>lcFieldName = "S" + ALLTRIM(EVAL(nSize))</b>
<b>If NoCnt = 1
Create Table myTable (code c(20))
Endif</b>
>> Alter Table Add column (<b>lcFieldName</b>)
>>Select MyCursor
>>skip
>>Endd
>>If this code success, the table's field will be looked like
>>
>> <---Size -->
>> code,10,20,25,30
The filed names will be
code,S10,S20,S25,S30
>>
>>
>>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--