>1) try it
>

>strSQL	   = CHRTRAN(strSQL, CHR(13) + CHR(10), CHAR(32))
>

>
>2) What MSSQL version you use? ---> sql 1008 r2 developer
>3) What ODBC driver and version you use? ---> Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Uid=sa;pwd=pcsoftw2
>4) What error you got after calling AERROR()? ---> HA!! thats it

you pointed me in the right direction. my connection string pointed to the wrong DB
thnaks

Peter
>
>MartinaJ
>
>>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