topic-13157

Board index FiveWin for Harbour/xHarbour Problem with scopes

Posts: 824

Joined: Thu Oct 13, 2005 07:39 AM

Problem with scopes
Posted: Thu Oct 16, 2008 08:38 AM

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 Collapse

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

kind regards

Stefan

Enrico Maria Giordano

Posts: 9022

Joined: Thu Oct 06, 2005 08:17 PM

Re: Problem with scopes
Posted: Thu Oct 16, 2008 09:17 AM

Code: Select all Collapse

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

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

StefanHaupt

Posts: 824

Joined: Thu Oct 13, 2005 07:39 AM

Problem with scopes
Posted: Mon Oct 20, 2008 07:16 AM

Enrico,

that´s it .

Many thanks

kind regards

Stefan

FiveTech Support Forums

Continue the discussion