Check what ODBC error AERROR() returns. Most likely you will need quotes around dates. See corrections inline below

>
>Can anybody suggest what may be wrong in this SPT to MS-SQL. It just returns -1 for the SQLEXEC():
>

>StartDate = thisform.fromdate.value
>EndDate = thisform.todate.value
>
>TEXT TO cVar NOSHOW TEXTMERGE
>   SELECT CAST(RTRIM(charfield) AS char(10)) AS charfld,
      '<<m.StartDate>>' AS StartDate, '<<m.EndDate>>' as EndDate
>   FROM myTable
>   LEFT JOIN ...
>   WHERE ...
      AND fld_EntryDate >= '<<m.StartDate>>'
      AND fld_EntryDate <= '<<m.EndDate>>'
>   ORDER BY ...
>ENDTEXT
>
>SQLEXEC(nHndl, cVar, "curname")
>