Article View: borland.public.vdbase.data.sql
Article #651Re: Difference in results using select, count or setRange
From: Nedim Buyukmihci
Date: Thu, 30 Jul 1998 00:00
Date: Thu, 30 Jul 1998 00:00
19 lines
1574 bytes
1574 bytes
For those interested in this thread: Steve Koterski offered one other suggestion to me: > It is possible that this is caused by an index, corrupt or not. Perhaps an > index with the UNIQUE constraint (unique indexes for level 7 dBASE tables > act as those from other table types, differing from original dBASE unique > index behavior). It could also be a combination of these factors and > soft-deleted records still in the table. Try doing a PACK to eliminate >still-existing soft-deleted records or a REINDEX to refresh any indexes. Although there was no Unique constraint on the index involved and there were no 'soft-deleted' records, I did a Pack then a reindex. After this, the sql statement and the dml statements resulted in the same results. I hope the dBASE developers will look into this. Ned
Technical Details
Message-ID:
<35c1a5fa.698141838@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35b4c26a.316071729@forums.inprise.com> <35b4d49a.1106345@forums.inprise.com> <35b704d1.1419530@forums.inprise.com> <35b61186.2940680@forums.inprise.com> <35b95591.87640982@forums.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,dba30251bf339334 X-Google-Attributes: gidff5a1,public From: ncbuyukmihci@ucdavis.edu (Nedim Buyukmihci) Subject: Re: Difference in results using select, count or setRange Date: 1998/07/30 Message-ID: <35c1a5fa.698141838@forums.inprise.com> X-Deja-AN: 376386908 Content-Transfer-Encoding: 7bit References: <35b4c26a.316071729@forums.inprise.com> <35b4d49a.1106345@forums.inprise.com> <35b704d1.1419530@forums.inprise.com> <35b61186.2940680@forums.inprise.com> <35b95591.87640982@forums.inprise.com> 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