Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Will this query take long time using SPT?
Message
From
17/11/2000 12:05:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Will this query take long time using SPT?
Miscellaneous
Thread ID:
00443073
Message ID:
00443073
Views:
38
Hi All,

Can someone please tell me whether the following query (using SQL pass-through) would take long time if the table grows into millions?

=SQLExec(nMyHandle, "SELECT * FROM mytable WHERE 1=2", "mycursor")

Actually what I want was the exact structure of back-end table and that is why I put a false WHERE clause.

Or is there another way to get the table structure into array or cursor?

Thanks for your time.

Regards
Vijay
Next
Reply
Map
View

Click here to load this message in the networking platform