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:
01075062
Views:
23
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
>
Zakaria al Azhar
My blog on Actuaris.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform