General information
Category:
Coding, syntax & commands
Title:
Create Table in run time (urgent)
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only