Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One Record or All Records in same view.
Message
From
21/08/2008 13:10:39
Sergey Berezniker
New York, United States
 
 
To
21/08/2008 12:49:47
Chris Foster
BenefitMall
Dallas, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: One Record or All Records in same view.
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01340612
Message ID:
01340838
Views:
11
>Integer primary key.

Run some tests to see which is faster/optimizable
WHERE EMPTY(?vp_PrimaryKey) OR Table.PrimaryKey = ?vp_PrimaryKey

* Or

* 1 Record
vp_PrimaryKeyMin = vp_PrimaryKey
vp_PrimaryKeyMax = vp_PrimaryKey
* All Records
vp_PrimaryKeyMin = 1
vp_PrimaryKeyMax = 2^32-1

WHERE Table.PrimaryKey BETWEEN ?vp_PrimaryKeyMin AND ?vp_PrimaryKeyMax
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform