Hi Peter,

You mean to send this to the original creater of the mail... Right?

>Just make sure you delete the index before you issue a tableupdate because it will fail otherwise.

BTW, Why would a TABLEUPDATE fail because of a SET ORDER TO TAG TagName from the Header's Click() on an Optimistically table buffered View/Table?

>
>Peter
>
>
>
>
>>Hi Zaraq,
>>
>>Create an index on DTOS(DateField) and issue SET FILTER TO TagName from the Grid.Header.Click() event.
>>
>>>I have a grid with 2 fields , the first field is a date field.I want to sort data in such a way that when I click the header of date field it sorts the dates in such a way that the dates are displayed chronologically i.e. 1-1-98 , 1-2-98 , 1-3-98 and so on... I have tried it with SORT MYDATETABLE ON DATEBOX /ASCENDING
>>>but to no avail.Your help will be most appreciated.I would like to thank Jess Banga for his help for my last query.
>>>Thank You All........
>>>Zaraq Bari