Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create table dynamically using strings within a class
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01075057
Message ID:
01075064
Views:
18
You are right :o)


>Hi Boris,
>I had to do a small correction to let it work :place cFieldStructure between (). Thanks it works great.
>
>>>Hi All,
>>>
>>>I managed to create a table dynamically using strings within a class function by the follwing code:
>>>
>>>FUNCTION test()
>>>cTableName = "gbm6165"
>>>cFieldStructure = [Age I, Lx N(10,4),Qx N(10,8),Dx N(10,4),Nx N(10,4),Sx N(10,4), Cx N(10,4),Mxstreep N(10,4),] + ;
>>>				  [Rxstreep N(10,4)]
>>>CREATE TABLE (cTAbleName)(&cFieldStructure)
>>>ENDFUNC
>>>
>>>
>>>In reality cFieldStructure is a property, but somehow I have to call it locally within the function to let the above code work. Now what I really want is something like this:
>>>
>>>CREATE TABLE (cTAbleName)(&this.cFieldStructure)
, but that fails
>>>
>>>Do you know what to correct?
>>>
>>>Thanks beforehand
>>
>>
>>TEXT TO lcCreate TEXTMERGE NOSHOW
>>     CREATE TABLE <<cTAbleName>> <<this.cFieldStructure>>
>>ENDTEXT
>>&lcCreate
>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform