🚀 go-pugleaf

Hi John,

What, then, do you suppose is the purpose of the Sort Expresson on the 
Columns tab of the Property Builder?

I notice that neither the Data Member nor the Data Key Field on the General 
tab of the Property Builder are persisted. Since both of these values would 
be required for the DBWebGrid to perform a sort, I suspect that this is 
related to the problem. Would you agree?


John

"John Moshakis" <john@moshakis.com> wrote in message 
news:43e18447@newsgroups.borland.com...
> John Mace wrote:
>
>> Hi,
>>
>> Using D2006E, I'm having a problem sorting a DBWebGrid. When I set
>> AllowSorting to True, the header is underlined and makes a round trip
>> to the server when clicked as expected. Althought the Sort Expression
>> is properly set through the Property Builder, the grid is not sorted.
>>
>> It seems to me that there is sufficient information in the property
>> settings to perform the sort. What am I missing?
>>
>> John
>
> Hi John,
>
> You need to add a SortCommand event handler and perform the sorting
> yourself.
>
> A couple of things to be aware of with the dbwebgrid. When you postback
> it applies any changes you have made on the client into the dataset.
> You therefore have to make sure that the selected row is the same
> before and after you have applied the sort. Something like
>
> SortCommand(source:TObject;e:DataGridSortCommandEventArgs)
> begin
> selectedIndex:=dbWebGrid1.SelectedIndex
> {get the primary key value for that row
> {perform the sort}
> {find the index of the row with the primary key value}
> (dbWebDataSource1 as Borland.Data.Web.IDBPostStateManager).SetCurrentRow
>
>
> end
>
> The other thing you need to be aware of that the dbwebdatasource is
> caching the dataset and I think this interferes with the sorting so set
> AutoRefresh to true and do the caching yourself.
>
>
> Cheers,
> John
> -- 
>