>I have the following statement in my .prg, which keeps on producing the error message "Function argument value, type, or count is invalid":
>
>lcSQLString = "INSERT INTO DatabaseName..TableName(field1,field2) VALUES("+;
>IIF(ISNULL(MyCursor.field1),NULL,"'"+ALLTRIM(MyCursor.field1)+"'")+","+;
>IIF(ISNULL(MyCursor.field2),NULL,ALLTRIM(STR(MyCursor.field2)))+")"
>
>where:
>field1 - character
>field2 - numeric
>
>When I turn debugger on to check the value of lcSQLString, it equals to .NULL.
>
>Does anyone have an explanation for this? Or a better way?
>
>TIA,
>CARIE
Yes, you must use "NULL", not just NULL in your expression, because you want to add the text NULL, not the value NULL (which is why your whole expression ends up as NULL.