>>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