Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XP SP1 Passing Parameters to SQL Server
Message
From
03/01/2003 19:48:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
XP SP1 Passing Parameters to SQL Server
Miscellaneous
Thread ID:
00737935
Message ID:
00737935
Views:
68
Has anyone else observed this behavior?

Building an .exe with VFP 7.0 SP1 and utilizing SQL Server 2000 SP2. I have no other configurations to test.

In Windows XP the following line of code will not work in XP Service Pack 1 but does work for XP without SP1 and all prior versions of Windows.
SQLEXEC(oApp.ch,"{CALL vsp_woValid(?lcJOBID,?lcEqid)}")
This line of code does work for all versions of Windows including XP SP1.
SQLEXEC(oApp.ch,"EXEC vsp_WoValid ?lcJOBID,?lcEqid")
Is there any advantage to using one method over the other? Perhaps Microsoft is no longer going to support the call functionality and I failed to catch that somewhere? Any thoughts or insights would be greatly appreciated.

Thank You
Next
Reply
Map
View

Click here to load this message in the networking platform