![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 9 of 9 total |
![]() |
Tue, Apr 10 2007 10:10 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
I've just converted a database to give me a decent sized table to play with and the results when applying filters to a result set are "not valid" Select * from mandn (149029 rows) filter _whoto = 'Addict' (5 rows) select * from mandn order by _subject (149029 rows) filter _whoto = 'Addict' (1 row) Note the subtle difference And at this point clear filter no longer works, and trying to rerun the query causes an AV I also get some weird behaviour when I reopen EDBMan like duplicates on the Windows task bar, av's on runing a query. I have to close down again and then its OK. Roy Lambert |
Tue, Apr 10 2007 10:20 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | I don't know just what happens but I had to shut down all four apps I had open and the processor was still thrashing at 100%. Power off required.
Roy Lambert |
Tue, Apr 10 2007 8:46 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< I've just converted a database to give me a decent sized table to play with and the results when applying filters to a result set are "not valid" Select * from mandn (149029 rows) filter _whoto = 'Addict' (5 rows) select * from mandn order by _subject (149029 rows) filter _whoto = 'Addict' (1 row) Note the subtle difference And at this point clear filter no longer works, and trying to rerun the query causes an AV >> I would repair the table. It sounds like you've got a corrupted table, especially if the second query is generating a sensitive (live) result set. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 11 2007 6:28 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
>I would repair the table. It sounds like you've got a corrupted table, >especially if the second query is generating a sensitive (live) result set. Repair of the table MandN started at 2007-04-11 08:30:07.0718 Repair of the table MandN ended at 2007-04-11 09:31:14.01710 I assume this means no problems found in which case back to you I'm just about to retest Roy Lambert |
Wed, Apr 11 2007 6:31 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
Just tested with the repaired table - same result Roy Lambert |
Wed, Apr 11 2007 2:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< Just tested with the repaired table - same result >> Could you send me the table in question (catalog also, please) ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 11 2007 2:54 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
c2Gb do you want me to post a DVD? Roy Lambert |
Wed, Apr 11 2007 4:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< c2Gb do you want me to post a DVD? >> Sure, either that or if you have someplace you can put it for download, I can download it from there. Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Apr 12 2007 5:16 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
It will be posted today Roy Lambert |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |