Again you are right! I had tried "'NULL'" and failed.


Now it's working like a charm. But in good ols VFP ways there isalways more than one solution.
Could this whole thing be done with a Cursor Adapter?

Thanks again

Peter


>Well, thanks to you I was able to find something that I did not know before:
>This works for me:
>

>sqlexec(gnConnHandle,"insert into table_name (flddate) values (" +;
>	iif(isnull(date_value) or empty(date_value), ;
>               "NULL", ;
>               "'"+dtoc(date_value)+"'")+")" )
>
>

>
>
>
>>so you are passing dates a character. hmmm.
>>
>>But it works! except for blank dates. THEN IT CHOCKES.
>>How does access want blank dates?
>>
>>Thanks
>>
>>Peter