Hi Sergy,

I remodified the code while waiting for your answer, Please see below.


If Empty(.Entrydate)
cEntrydate = "NULL "
Else
cEntrydate = [{] + Dtoc(.Entrydate) + [}]
Endif

cSQL = [INSERT INTO bbfs!callinv(] +;
[dcno,] +;
[callrefno,] +;
[entrydate,] +;
[calldate)] +;
[values(] + Alltrim(Str(cDcno)) + [,] +;
+ Alltrim(Str(cCallrefno)) + [,] +;
+ cEntrydate + [,] +;
+ cCalldate + [)]

This code works fine, but when I tried to include a logical field, it does not insert the record to the table anymore. Please see code below.

cSQL = [INSERT INTO bbfs!callinv(] +;
[dcno,] +;
[callrefno,] +;
[status,] +;
[entrydate,] +;
[calldate)] +;
[values(] + Alltrim(Str(cDcno)) + [,] +;
+ Alltrim(Str(cCallrefno)) + [,] +;
+ [.F.] + [,] +;
+ cEntrydate + [,] +;
+ cCalldate + [)]