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
bye, Emanuele!
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.