General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi All:
I am able to get the value into the lcstring correctly,however, it is not creating a table with specificed number of fields. Here is my code. Can someone please help me out.
If lnCount <= 255
lcstring = [CREATE TABLE &lcTxt (]
For ii = 1 to lnCount && lnCount has the number of fields in a given table.
lcstring = lcstring + ['Field' ] + transform(ii) + [ c(20),]
if ii = lncount then
* strip off last ","
lcstring = left(lcstring,len(lcstring)-1)
endif
EndFor
* add trailing parenthesis for Create Tabel command
lcstring = lcstring + [)]
&lcstring && I don't know where to go from here, lcString does have the value
Thanks
MA
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