Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec or SQLPrepare + SQLExec ???
Message
From
19/02/1999 19:03:06
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLExec or SQLPrepare + SQLExec ???
Miscellaneous
Thread ID:
00189574
Message ID:
00189574
Views:
61
Hi All,

I was wondering...

What's the difference between using:

1) The SQLExec with the embedded query string
2) The SQLprepare with the query string followed by an SQLExec

The help mentions that SQLPrepare send the query string for
compilation by the ODBC data source. This compiling is not
mentionned for the SQLExec command.

Does this mean that SQLExec without an SQLPrepare will
run my queries slower ?

Or is it just a question of personal choice?

TIA

Pascal
Next
Reply
Map
View

Click here to load this message in the networking platform