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 + [)]
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.