>Hi.
>I am converting a VFP table with date fields to a SQL server table with DateTime fields . (I am assumiong the DateTime field is the correct type of field ?)
>I am using the Insert SQLEXEC command... how do I convert the VFP date field to a SQL DateTime field ?
>
>Regards,
>Gerard
vardate = DATE()
TEXT TO Mysql TEXTMERGE NOSHOW
INSERT INTO Table1 (MyDate) VALUES('<<DTOS(m.vardate)>>')
ENDTEXT
lnSqlResult = SQLEXEC(MyConnH,MySql)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst