It worked on my system also. If you are using enterprise manager to see the view, you need to refresh EM after dropping the view.

PS: Two hyphens (--) is the SQL-92 standard indicator for comments.


Kurt


>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