delete a record

[Sylvain Perque]

Win 2000
Director MX 2004
V4MD v2 (05/05/2005) I bought it the 17 05 2006 and didn't update it.

gDb.sqlExecute("REINDEX TABLE name_of_my_table") didn't solve the problem.

Sylvain

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Tuesday, April 03, 2007 2:41 PM
Subject: Re: delete a record


> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>