Hi Mike,
See below,
>
>Here is the code that im having problem with. It's an insert sql command using the tips that you gave me in the update. The update command works but it does not work with the insert command. I think I have a logical error with this one for it does not generate any error.
>If Empty(.Entrydate)
> cEntrydate = "NULL "
>Else
> cEntrydate = [{] + Dtoc(.Entrydate) + [}]
>Endif
>
cSQL = [INSERT INTO bbfs!callinv( dcno, callrefno, entrydate) ] + ;
[values("] + Alltrim(Str(cdcno)) + [","] +;
Alltrim(Str(cdcno)) + [",] +;
+ cEntrydate + [)]
--sb--