i have the following code:

TEXT TO strSQL NOSHOW TEXTMERGE PRETEXT 15
	SELECT
		 f1.CLAIM_ID,
		 f1.CLAIMNO,
		 f1.WCCNO,
		 f1.INDEXNO,
		 f1.PARENT_ID,
		 f1.CLAIMNT_ID,
		 f1.ANALYST_ID,
		 f1.STATUTE_ID,
		 f1.BUSLOC_ID,
		 f1.DOCCURED,
		 f1.DCLOSED,
		 f1.XFERDATE,
		 f1.LIABDATE,
		 f1.STATUS,
		 f1.STATDATE,
		 f1.BOX_ID,
		 f1.OCCUPATION,
		 f1.ACCTIME,
		 f1.AGE,
		 f1.AVGWEEKLYPAY,
		 f1.BASERATE,
		 f1.BENEFITAMOUNT,
		 f1.WORKLIFE,
		 f1.WORKEXPECT,
		 f1.LIFEEXPECT,
		 f1.RTWPOTL,
		 f1.LIFEMED,
		 f1.COMPINJ,
		 f1.PERMPERC,
		 f1.MEDFLAG,
		 f1.PERMTOT,
		 f1.TTDLIFE,
		 f1.RESTICTIONS,
		 f1.ESCALATE,
		 f1.INFLATE,
		 f1.DRECVD,
		 f1.EXPREC,
		 f1.SOURCE,
		 f1.COMMENTS,
		 f1.W3,
		 f1.IP,
		 f1.MP,
		 f1.TP,
		 f1.SIFSHARE,
		 f1.SIFRATE,
		 CAST(f1.insdttm AS DATE)  AS addDate,
		 f2.lname,
		 f2.fname,
		 f2.mname,
		 f2.SSN,
		 f5.boxname AS boxname,
		 f2.onpayroll,
		 f3.CODE AS STATUTE,
		 f6.username AS analyst,
		 CAST(' ' AS CHAR(15)) AS signout,
		 carrier_id 
		FROM claims f1 
		LEFT OUTER JOIN CLAIMNT f2 
			ON f1.CLAIMNT_ID = f2.CLAIMNT_ID 
		LEFT OUTER JOIN STATUTE f3 
			ON f1.STATUTE_ID = f3.STATUTE_ID 
		LEFT OUTER JOIN filebox f5 
			ON f1.BOX_ID = f5.filebox_ID 
		LEFT OUTER JOIN SYS_USER f6 
			ON f1.ANALYST_ID = f6.user_ID 
		WHERE  1 = 0 
		ORDER BY 2, 1

ENDTEXT

THIS.iConn = SQLSTRINGCONNECT(THIS.cConnectionString)   &&&     returns 1
strSQL	   = CHRTRAN(strSQL, CHR(13) + CHR(10), [])
intResults = SQLEXEC(THIS.iConn, strSQL, [ccPRINT])                &&&& returns -1
_CLIPTEXT  = strSQL
* copied inti SSMS this query WORKS

why would it not work from vfp but work as query in SSMS?

Peter