I would have assumed that a permission issue would have raised an error and SQLEXEC() would return -1.

If SQL Server can't tell that the batch consist of multiple lines, the comment could be applied to the DROP VIEW.

-Mike

>Could this be a permissions issue?
>
>How have you created the connection to the SQL Server from VFP?
>
>Cheers,
>
>Andrew
>
>>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.
>>
>>PS: For who have no experience on MS SQL SERVER the '--' is the starting command statement.
>>
>>AnyOne have an idea of this behavior ??
>>
>>Thanx in adcvance!
>>Emanuele