Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TEXT ..ENDTEXT question
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01536945
Message ID:
01536952
Views:
58
lField3Exist = .F.

TEXT TO lcText TEXTMERGE NOSHOW PRETEXT 15
  INSERT INTO MYTABLE (FIELD1, FIELD2 <<IIF(lField3Exist, ", Field3", "")>>) 
  		VALUE (?MYTABLE.FIELD1, ?MYTABLE.FIELD2 <<IIF(lField3Exist, ", ?MYTABLE.FIELD3", "")>>)
ENDTEXT
>
>How can I make the TEXT..ENDTEXT to add or remove text based on some variable value. For example. Say I have this code:
>
>
>TEXT TO cText NOSHOW
>  INSERT INTO MYTABLE (FIELD1, FIELD2) VALUE (?MYTABLE.FIELD1, ?MYTABLE.FIELD2)
>ENDTEXT
>
>
>Now I want to add FIELD3 to the above expression but only if some variable lField3Exist is .T. How would I change the above expression? TIA.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform