Great! Thanks

Peter



>>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
>
>Don't use CHRTRAN here, pass strSQL as is. Also, you don't need TEXTMERGE in the above and don't need PRETEXT.