question about Scopes

[ukservice]

Hello,

I have a database with tree indexes, code, name and state:

CUSTOMER.DBF

CODE
NAME
ADDRESS
PHONE
STATE

I would like to set an Scope as an alternative to SET FILTER to xbrowse customers in state = "NY", instead of using:

Code: Select all  Expand view

SET FILTER TO FIELD->STATE = "NY"

But I want to order the results by code, but this is index 1.

if I set the scope such as:

Code: Select all  Expand view

SET ORDER TO 3

      OrdScope( 0, "NY" )
      OrdScope( 1, "NY" )
      Dbgotop()

     XBROWSE()

      OrdScope( 0, Nil )
      OrdScope( 1, Nil )

     SET ORDER TO 1
 

But I want the results ordered by code or number, not state.

Is it possible?.

Thank you very much .

[ADutheil]

You have to create an index state+code_number and use the scope the way you did. The result will be shown order by code_number for the scoped state.

[ukservice]

Thank you.

So I have to change SET ORDER TO 3.

That is what I wanted to avoid.

Thanks

[ADutheil]

If you dont wat to change your index you might reopen you dbf with another alias set its order to 3, scope it, browse what you need and close it when finished.

[Marc Vanzegbroeck]

Why do you want to avoid that?

If you not using the index on 'state' somewhere else in your program, you can change the index 3 to state+code_number,
otherwise you can add a 4th index and use tis one for your scope.

Marc

[ukservice]

Marc,

As it is runned in a network eviroment.

Thanks for helping

[James Bott]

>As it is runned in a network environment.

Why does that matter? If you are concerned about speed, then I expect it is still going to be way faster than a filter.

Regards,
James