>I found an incredible behavior of SQL + VFP.
>follow the steps:
>1) Craete a little on MSSQLServer like this
> create view vdummy as select * FROM sysobjects where 1=0
>2) from vfp use this simple code (i'm usign vfp 7)
>TEXT TO cSample NOSHOW
>--vDummy
>DROP VIEW vDummy
>ENDTEXT
>
>3) create a connection to SQL SERVER from VFP and set nHandle like sql connection handle
>
>4) issue this command on VFP: SQLEXEC(nHandle, cSample)
>
>Now if you see the database you can notice that the view vDummy isn't dropped.
>
>But if you capture the code between TEXT... ENDTEXT and execute the script on SQL analyzer the view will be drop.
"Capture" as in "select the text in vfp editor and press ctrl+c" or setting _cliptext=cSample in command window, having suspended after the EndText? The second may show whether the crlf between the lines was really there. If it wasn't, it may have been understood as a single line, i.e. just a comment. Try inserting a blank line before the drop command.