delete a record

[Ruslan Zasukhin]

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

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

Wait. Please note

TEXT field usually is Indexed By Words.

Indexed By words field cannot be sorted.


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