>>>>I need to sort data in ascending order in the Grid.
>>>>I have created a key index(CDX) for the table to
>>>>associate to the Grid.
>>>>The problem is that I am still unable to view the data
>>>>in ascending order after setting the index order
>>>>eg. open database (databasename)
>>>> select (tablename)
>>>> set index to (tagname)
>>>>
>>>>Pls advise, thanks.
>>>
>>>Have you verified that the index is what oyu think it is by setting order and browsing the table?
>>>
>>>How are you assigning the grid's recordsource? In the property sheet, or in code? Is the table open in the form's DataEnvironment?
>>>
>>>The following simple steps should make a table viewable in a grid in a specified order.
>>>
>>>Create a form, and drop a grid on it.
>>>Add the table in question to the Data Environment.
>>>SEt the Cursor's Order property to the name of the index you created
>>>Set the grid's redordsource property to the name of the cursor.
>>>Run the form.
>>
>>Thanks for the advise. I have tried the method you suggested,
>>but still could grt the effect.
>>Yes, I have include the table into the Data Environment and all
>>that you suggested, but still could work.
>>I tried using the Command Box(in VFP) to open the table and
>>set the index tag and Browse, it is in order, but when I put it
>>into Grid, it doesn't seems to behave properly.
>>
>>In Grid, RecordSource = (tablename)
>> RecordSourceType = Table
>>BTW, the Grid was placed in the PageFrame.
>>
>>Anywhere could went wrong?
>
>
>Where did you set the order of the cursor in the form?

Yes, I set Order in the Data Environment that associated to the
Table that data should display in the Grid. Is it correct place?