Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field names, month change.
Message
 
 
To
15/03/2001 11:34:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00485410
Message ID:
00485428
Views:
11
>Hi all,
>
>I have in my Table some fields like 'n_01_ent, n_02_ent, n_03_ent...'.
>
>Now i need to update them by month numeric value, but i don't want to go thru 12 months in a if condiction.
>
>Is there any way to change that like 'replace n_'myVar_Month'_ent with SomeValue, with one code line i change what i need.
>
>Thank's
>
>João Batista

You can use Name Expression for a field name
replace ("n_" + PADL(INT(myVar_Month), 2, "0") + "_ent") with SomeValue
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform