Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized views and integer primary keys
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00236927
Message ID:
00237407
Views:
12
>>Chris,
>>
>>It's a bit awkward, but you could paramaterize your view on this:
>>
>>JobID >= ?m.liJobLow AND JobID<=?m.liJobHigh
>>
>>To get one record set liJobLow and liJobHigh to the key. To get them all set liJobLow and liJobHigh to the min and max values of an integer key: -2147483647 and 2147483647 respectively.
>>
>
>This is exactly what QBF Builder does for you...and does it all automagically.

Using the high low view parms for each criteria element also gives you >, >=, <, <=, Between, and Empty.

And in QBF Builder 2.0, we have also added the new ViewLink style of query which doesn't use view parameters at all, instead we automatically bind your view to dynamic criteria allowing much more flexibility than is possible with view parameters (such as Like, InList, NULL, Contains, ...).
R. Scott Mackay
Classy Components Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform