>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.
If it's not broken, fix it until it is.
My Blog