>>>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?
Erik Moore
Clientelligence