Hi Sergey,

I now trying to insert date time values with date time fields, I just can't make it work properly. Can you help me with this one. Thanks..

cEdtdt = ["] + Datetime() + ["]
cRegdt = ["] + Datetime() + ["]

cSQL = [INSERT INTO bbfs!dispatchinv(] +;
>>>>>>>[dcno,] +;
>>>>>>>[dispatchno,]+;
>>>>>>>[edtdt,] +;
>>>>>>>[regdt,] +;
[values( ] + Alltrim(Str(cDcno)) + [,] +; >>>>>>>>>>>+ Alltrim(Str(cDispatchno)) + [,] +;
>>>>>>>>>>>cEdtdt + [,] +; >>>>>>>>>>>cRegdt + [)]