Problem with sort / index is incorrect

[Ruslan Zasukhin]

On 5/28/04 1:31 AM, "Matthew Jew" <mjew at icnc.com> wrote:

> Ruslan,
> 
> I have a Cocoa application that samples several web servers for "hit"
> statistics and such.
> Using this data, it calculates about 10 different sets of statistics.
> 
> Much like the old Cocoa Demo app, the user can click on a column to
> sort the table by that column.
> 
> My problem is that the result of the Sort() is not the proper order.
> I determined that the Sort does not return the correct order because
> the index is not right.
> 
> If I throw out the .ind (thereby causing Valentina to rebuild the
> index), then everything is OK.
> However, if I add more data, the Sort order quickly becomes incorrect
> again.
> 
> I do not think one should have to keep discarding and rebuilding
> indices to get proper Sort results.
> I can send you a copy of the program with a corrupted sample database.
> 
> Am I doing something wrong?
> 
> I am using version 1.10 of the VSDK.framework.

Hi Mathew,

Of course indexes must not go out of date.

1) just a note: in Valentina 2.0 I have add Diagnose() for indexes.
    so it will be possible to see WHICH exactly index get problems.

2) Sort on which field fails? Numeric? String?

3) already bad db is not helpful.

Can you get it in this way:
A) you have good db
B) you add some records
C) result in bad db?

Having this I could debug it.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------