>The following code give me a ODBC error for field "dateField" :
> "Error converting data type varchar to numeric"
>
>Why, if is a Date Field ?!!
>
> SQLCommand = "Insert into Mytable" + ;
> "(ccod_art, cDesc_art, dateField)" + ;
> "Values ('" + ALLTRIM(mytable.ccod_art) + "', '" +;
> ALLTRIM(mytable.cdesc_art) + "', '" +;
> '08-08-2001' + "')"
>
> SQLResult = SQLEXEC(nFileHand, SQLCommand)
>
>Thank you.
Is that a typo or are you doing double quotes for the date literal? (08-08-2001)
"', '" + '08-08-2001' + "')"
shouldn't it be:
"', " + '08-08-2001' + ")"