>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 + [)]

Mike,
cEdtdt = ["] + Datetime() + ["]

Would error. You're tring to concatanate a datetime value with char values. Is it needed for SQL server with SQL pass through ? If so SQL pass through and remotevies use ODBC connection and datetime values need to be in ODBC canonical format ('YYYY/MM/DD hh:mm:ss').

store transform(ttoc(datetime()-100000,1),'@R 9999/99/99 99:99:99') ;
 to cEdtdt,cRegdt

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

However for datetime() you could directly use SQL server's GetDate() function :

cSQL = [INSERT INTO dispatchinv ] +;
  [ (dcno,dispatchno,edtdt,regdt)] +;	
  [ values( ] + Str(cDcno) + [,] +;
  Str(cDispatchno)+ [, GetDate(), GetDate() )]

OTOH seeing 'bbfs!dispatchinv' I guess this is not SQL server but VFP. Then corresponding syntax of above would be :

store '{'+;
 transform(ttoc(datetime()-100000,1),'@R ^9999/99/99 99:99:99') + '}' ;
 to cEdtdt,cRegdt

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

Directly using datetime() :

cSQL = [INSERT INTO dispatchinv ] +;
  [ (dcno,dispatchno,edtdt,regdt)] +;	
  [ values( ] + Str(cDcno) + [,] +;
  Str(cDispatchno)+ [, Datetime(), DateTime() )]

Cetin