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
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.