Hi Sergey.. I have the date working now.

I used "'" + Dtos(MyDate) + "'"
So a combination of Dtos and single quotes seemd to work.

Thaks again for all your assistance.

Gerard




>>I get no error code back.. and it creates the records ok
>
>You did say in the previous message that you got error with '?", didn't you?
>
>>Code is below and Doc_Date is a Dtae Time field in SqlServer
>>
>>
>> myn = SqlExec(lnHandle,"Insert into Docs " +;
>> "(Doc_ref, Doc_Type, Doc_from, Doc_to, Doc_Compan, Doc_Claim, Doc_MeetWi,;
>> Doc_MeetAr, Doc_Subjec, Doc_Contac, Doc_Contnu, Doc_Safepa, Doc_Comm, Doc_relat,;
>> Doc_Transm,Doc_Val,Doc_date)" + ;
>> " VALUES('" + F01 + "','" + F03 + "','" + F04 + "','" + F05 + "','" + F06 + "','" + F07 + "','" +;
>> F08 + "','" + F09 + "','" + F10 + "','" + F14 + "','" + F15 + "','" + F16 + "','" +;
>> F17 + "','" + F19 + "','" + F20 + "'," + STR(F18,10,2) + "," +;
>> DTOC(DATE()) +;
>> ")")
>>
>It's impossible to read this code. I would strongly recommend to rewrite it using TEXTMERGE.