>>>Here's the thing:
>>>- A grid vith the parameterized view
>>>- Column order gets changed by the user
>>>- Shortly after the view (source) gets Requery()d with totaly different parameters, and grid refreshes
>>>- User ends up with modified order of grid columns, but original order of data(view) columns
>>>Why doesn't the data follow the grid's column order?
>>>
>>>Cheers
>>Hi,
>>
>> There is no co-relation between data and grid. both of these are different entities. If you want to Order By the View, you would create an index on it runtime.
>>
>>Bye
>>Jayesh
>
>Yes, I am actually aware of that. I was wondering, however, if it's possible to make the grid follow, or reset the column order of the grid to the original order.
>
>Thanks for your input anyway

Hi,

Sure,You can do that.

1. Create an array on the form level.
2. Store current column orders in the init of the Grid into array.
3. Restore original Column Order whenever you REQUERY() the view.

Let me know if you want sample code.

Bye
Jayesh