>>>Hi,
>>>
>>>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.
>>
>>What about creating two separate cText
>>
>>IF lFieldExists
>> text to ...
>>
>>ELSE
>> text to
>
>
>Alternatively, you can
>
>text to lcText noshow textmerge
>
> insert into myTable (Field1, Field2 <<iif lFieldExists, ',field3','')>>) values ((?MYTABLE.FIELD1, ?MYTABLE.FIELD2 <<iif (lFieldExists, ',?MyTable.field3','')>>)
>
>endtext
I think (without trying) is exactly what I am looking for. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham