Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Table
Miscellaneous
Thread ID:
00453575
Message ID:
00453583
Views:
19
>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.
<b>	lcstring = lcstring + ['Field] + transform(ii) + [' c(20),]</b>
>       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
Minor change in bold above (moved the closing quote). After thge program runs, you should have a table on disk with the name specified in the lcTxt variable.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform