Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table
Miscellaneous
Thread ID:
00453575
Message ID:
00453575
Views:
54
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
Map
View

Click here to load this message in the networking platform