Problem with scopes

[StefanHaupt]

Hi all,

I have a curious problem using scopes.


My scenario:

I have a database with a field named "gruppe1", the dbf is indexed on this field (index on Lower(Gruppe1) tag ...) and this tag has the focus.

Now I want the set the scope on articles of a certain group called "alufelgen". The scope is working with the exception that articles of the group "alufelgen-gebr" are also in this scope and they should not.

Code: Select all  Expand view

SET SCOPE TO "alufelgen","alufelgen"

After reading the doku I found that the content of the field is compared against the expression of the scope.

That means, "alufelgen-gebr" < "alufelgen" is .t., even if SET EXACT is ON.

Does anyone have an idea how to solve this problem and to change the behavior of ordscope() ?

Thanks

[Enrico Maria Giordano]

Code: Select all  Expand view

SET SCOPE TO PadR( "alufelgen", Len( gruppe1 ) ),PadR( "alufelgen", Len( gruppe1 ) )

EMG

[StefanHaupt]

Enrico,

that´s it .

Many thanks