delete a record

[Sylvain Perque]

Hi,

I use valentina with director.
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
or can I flush 1 time at the end, when the 10 records are deleted ?
(I tried the 2 solutions, but the problem is always present).

Thanks
Sylvain