delete a record

[Ruslan Zasukhin]

On 3/4/07 12:33 PM, "Sylvain Perque" <sylvain.perque at ac-reims.fr> wrote:

Hi Sylvain,
 
> I use valentina with director.

OS? Version?

> When I add some records I can sort them without problem.
> When I delete some records, then I add other records, the new records aren't
> sort properly.
> What do I do wrong ?
> 
> Here is the way I delete a record :
> gCursor = gDb.sqlSelect(query, #kServer, #kReadWrite, #kRandom)
> 
> gCursor.firstRecord()
> 
> gCursor.deleteRecord()
> 
> gDb.flush()
> 
> I can write more if necessary.
> 
> When I have 10 records to delete, must I flush each time I delete a records

no

> or can I flush 1 time at the end, when the 10 records are deleted ?

yes

> (I tried the 2 solutions, but the problem is always present).

By what filed you do sorting?

To localize issue: 
    after delete - try
            REINDEX DATABASE
    or      REINDEX TABLE
    or      REINDEX FIELD you are sorting.

If REINDEX fix problem then sounds like issue with index.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]