Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I don't understand.
Message
From
14/08/2003 05:15:06
 
 
To
13/08/2003 12:46:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00819794
Message ID:
00820044
Views:
18
Sorry Cetin, bad writing.

I send this on SQL Query Analyzer ( and on VFP SPT ).
USE pubs

exec sp_executesql N'USE master; SELECT @P1   ; SELECT DB_NAME()'
, N'@P1 INT',  1

SELECT DB_NAME()
result:
1

master

pubs
It is correct, the USE database within sp_executesql is valid only
within sp_executesql.

From the first moment, it would seem that the same commando, constructed from VFP in order to replace the ?parameter,
renders effective commando USE ( executed within sp_executesql ) in the connection , but I do not find one explanation.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform