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")
or gDb.sqlExecute("REINDEX DATABASE")
or gDb.sqlExecute("REINDEX FIELD name_of_the_DateTimeField")
didn't solve the problem.


It doesn't sort with a DateTime field and with a Text and DateTime field.
I tried with only a text field, but it don't works.

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