>Hi,
>
>I need to change the following SQL Insert such that if the cursor cViewName does not have a column FIELD1 (or any other), this column IS NOT included in the expression. Here is an example:
>
>

>INSERT INTO (cViewName) (FIELD1, FIELD2, FIELD3) VALUES  ( "", "", 0.00 )
>

>
>I know I can do it with an IF ENDIF condition but I wonder if it can be done in one line.
>
>TIA

You can generate your INSERT command as a string using SET TEXT TO lcSQL TEXTMERGE NOSHOW and then you would need to execute it.