Try this:

?sqlexec(gnConnHandle,"INSERT INTO CLAIMS1 (CLAIMNO) VALUES ("+;
    iif(type("X1")="C", "'"+X1+"'", iif(type("X1")="D", "'"+dtoc(X1)+"'", trans(X1) ))+  ")" )

>I am almost there. I works with cahr fields but what to do with a date field
>Peter
>
>>
>>I believe, it will not work because (at least) the variable X1 will not be recognized there: the value of X1 should be passed, and it should be formatted depending on whether it is numeric, character, or other type. I assume that you have either character or numeric data types. Then try this:
>>
>>

>>?sqlexec(gnConnHandle,"INSERT INTO CLAIMS1 (CLAIMNO) VALUES ("+;
>>    iif(type("X1")="C", "'"+X1+"'", trans(X1) )+  ")" )
>>

>>
>>Let me know....