Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why use SQLPREPARE() ?
Message
 
To
15/08/2006 13:29:42
Marc Levesque
La Prairie, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Why use SQLPREPARE() ?
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01145665
Message ID:
01145716
Views:
23
This message has been marked as a message which has helped to the initial question of the thread.
Marc, check out
http://blogs.msdn.com/vsdata/archive/2004/03/16/90844.aspx
for more info.

>What's the difference between both...
>
>----------------------------------
>=sqlprepare(nHandle, cSQLString)
>=sqlexec(nHandle)
>----------------------------------
>=sqlexec(nHandle, cSQLString)
>----------------------------------
>
>Why use one instead the other?
>What about gain of performance?
>
>Thank you!
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform