Allan,
As Larry said it's not and if AutoTranslate is not in effect insertions are likely to fail. To be sure pass them in ODBC canonical format - YYYY/MM/DD hh:mm:ss. It's how SQL server expects via ODBC (convert() function's style 102)
For date(), datetime(), month(), day() etc you could use SQL server's Getdate(), datepart() etc functions.
Cetin
>Thanks Sergey. I didn't think it would be that simple.
>
>>>Now, I want to do the same thing with datetime and numeric fields. How would I handle inserting records with those data types using SQLEXEC?
>>The datetime value in SQL Server is represented by a character string.
...
>>strSQL = strSQL + Transform(lnNumber) + ", "
>>strSQL = strSQL + "'" + DTOC(ldDate) + "', "
>>strSQL = strSQL + "'" + TTOC(ltDatetime) + "', "
>>...
>>