Paradox hangs when scrolling past last record on filtered table

Dave Loveridge

unread,

Oct 4, 2004, 6:43:21 PM10/4/04

to corel.developer.paradox

I have a form with a table and I am filtering on one field. When the filter
is active and I scroll past the last record on the table, paradox hangs and
I have to end task it. I have tried all I can think of and I have never had
this problem before.
When there is no filter set it does not hang.
And I have tried recreating the form completely and it still does the same
thing.
Thanks in advance
Dave

Steven Green

unread,

Oct 4, 2004, 6:49:48 PM10/4/04

to corel.developer.paradox

Dave Loveridge wrote:

> I have a form with a table and I am filtering on one field. When the filter
> is active and I scroll past the last record on the table, paradox hangs and I
> have to end task it.

do you have a sec index on that field?.. the behavior you describe usually
means a damaged index file.. delete and re-create the sec index..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox
---------------------------------------------------
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Trading Cards and other Sports Memorabilia
---------------------------------------------------

Dave Loveridge

unread,

Oct 4, 2004, 7:12:34 PM10/4/04

to corel.developer.paradox

No I don't have a secondary index, but it does have table lookups setup and
when I go to that tab it tells me that a val file is out of date

"Steven Green" <gre...@diamondsg.com> wrote in message
news:4161D38C...@diamondsg.com...

Steven Green

unread,

Oct 4, 2004, 7:44:29 PM10/4/04

to corel.developer.paradox

Dave Loveridge wrote:

> No I don't have a secondary index, but it does have table lookups setup and
> when I go to that tab it tells me that a val file is out of date

damaged and/or missing lookup table..

Dave Loveridge

unread,

Oct 4, 2004, 9:54:04 PM10/4/04

to corel.developer.paradox

Well, I copied the table to another directory, deleted all lookups, etc,
deleted the val file, and still no success. On note though, this is a
version 5 table and it hase over 130,000 records also. Could this be a
problem

Dave Loveridge

unread,

Oct 4, 2004, 10:15:46 PM10/4/04

to corel.developer.paradox

I just tried it again and it works, it just takes a long time to think
about it. A few minutes actually.

Steven Green

unread,

Oct 5, 2004, 6:31:05 AM10/5/04

to corel.developer.paradox

Dave Loveridge wrote:

> I just tried it again and it works, it just takes a long time to think about
> it. A few minutes actually.
>

rebuild the table with the repair tool, then restruct it to pack it.. then see
what happens..

Dennis Santoro

unread,

Oct 5, 2004, 9:53:48 AM10/5/04

to corel.developer.paradox

You might try turning off autoappend on the table in the data model. That should
keep you from going past the last record under normal circumstances.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits since
1982

G. Rambaldi - Rambaldi Sistemi

unread,

Oct 5, 2004, 10:55:34 AM10/5/04

to corel.developer.paradox

For me, this is a normal behavior for large Paradox table with a Filter (if
you make a SetRange(), you have a good speed).
In this case Paradox is very very slow, but not hangs. The same if you make
a search (with Ctrl-Z) with a pattern that not exist in a filtered table.

"Dave Loveridge" <ddlatloveridgema...@cnews1.corel.dmz> ha
scritto nel messaggio news:4161cc0f$1_2@cnews...