db.flush required?

[Ruslan Zasukhin]

on 11/21/03 2:05 AM, jda at jda at his.com wrote:

> That's what I thought. And it turns out the bug is more complicated
> (db.flush doesn't always work).
> 
> Basically, the problem is that sorting isn't working under certain
> circumstances when the field being sorted is EMPTY.
> 
> The SQL query is
> 
> select id,hit,authors,date,title from references where hit>0 ORDER by
> authorsSortMethod
> 
> where
> 
>  authorsSortMethod = new VText("authorsSortMethod", 128, "English",
> kV_Indexed)
>  authorsSortMethod.SetMethod("Upper(authors)")
> 
> If I create some records with an empty authors field it initially
> sorts fine. BUT, if I close and reopen the database, the sort order
> is wrong (seems random, with records without authors intermixed with
> those that do). Reindexing the database usually fixes this, but it
> reappears as soon as the database is closed and reopened.
> 
> I can reproduce this with a fresh database (1.9.8, RB 4.5.3 or 5.2.3fc3).

If you can reproduce this, then please send me something.
As simple as possible :-)

-- 
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
-------------------------------------------------------------