Hi,

If i send this with SPT on MSQL:

USE pub

next send:

USE Master; SELECT ?par  ; SELECT DB_NAME()

VFP ask me par, i put 1.
On MSQL Profiler i see:

exec sp_executesql N'USE Master; SELECT @P1   ; SELECT DB_NAME()', N'@P1 int', 1

Now i send on connection:

SELECT DB_NAME()

I get Master !!!!! why ?

But if i send:

USE pub

and

exec sp_executesql N'USE Master; SELECT @P1   ; SELECT DB_NAME()', N'@P1 

and

SELECT DB_NAME()

I get pub. I aspect this.

Where is VFP trick ?

Thanks