Difference in results using select, count or setRange

Article View: borland.public.vdbase.data.sql

Article #800

Back to borland.public.vdbase.data.sql Previous Next

#800

From: Nedim Buyukmihci
Date: Tue, 21 Jul 1998 00:00

16 lines
1004 bytes

VdB 7.01 (b1419), Win95

A particular table has 543 records having zipcodes of 94000 to 96200
inclusive (determined by various counts).

If set the indexName to Zipcode and then do a rowset.setRange(low,
high), get 543 as expected.

But, if you try to do a select * statement with the two conditions:

  select * from <table> where <field> >= '94000' and <field> <=
'96200'

this gives only 199 records. Why would there be this discrepancy?

Ned

Technical Details

Message-ID: <35b4c26a.316071729@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,dba30251bf339334,start
X-Google-Attributes: gidff5a1,public
From: ncbuyukmihci@ucdavis.edu (Nedim Buyukmihci)
Subject: Difference in results using select, count or setRange
Date: 1998/07/21
Message-ID: <35b4c26a.316071729@forums.inprise.com>
X-Deja-AN: 373560362
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: PigByte Data�
Mime-Version: 1.0
Reply-To: ncbuyukmihci@ucdavis.edu
Newsgroups: borland.public.vdbase.data.sql