>>>>>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?
Do you have any other code in the form?
Erik Moore
Clientelligence