RE: D3 and use of compares on indices

2004-02-17 Thread astarte00
Well -- the key is indexed...and so is the date field so the caveat does not apply in this case -- more likely the elusive version 8 is the answer -- Debster -- From Lee Bacall: A bit of a caveat in making selects against indexed keys may be helpful... If one is

Re: D3 and use of compares on indices

2004-02-15 Thread Lee Bacall
A bit of a caveat in making selects against indexed keys may be helpful... If one is doing a select against a file with an indexed key, as: SELECT YOURFILE WITH YOURKEY = YOURREQUEST will build a select list against only those records containing the key data YOURREQUEST If, on the other hand if

D3 and use of compares on indices

2004-02-13 Thread astarte00
On D3 VERION 7.3 what is the syntax to use compares other than = if you are using an indexed dictionary in the statement. It seems to return the correct items if it is simply looking for an equal condition but anything other, such as etc. It appears that it does not use the index, but