>>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.