BROWSE / FILTER / PgUp

[AUGE_OHR]

hi,

i know SET FILTER is slow ... but when have a "simple" FILTER it most work

Code: Select all

   ORDSETFOCUS( 0 )  // no active Index TAG
   SET FILTER TO ( TRIM( LOWER( cWorkKeyWord ) ) $ TRIM( LOWER( FORUM->CODE ) ) .OR. ;
                   TRIM( LOWER( cWorkKeyWord ) ) $ TRIM( LOWER( FORUM->BODY ) ) )

when PgDown it work well but PgUp work bad ... why

p.s. both FIELD are MEMO, about 40000 Records

---

does BROWSE / GRID have a Solution to show "EOF" / "BOF" when reach by press PgUp / PgDown

[dragancesu]

does BROWSE / GRID have a Solution to show "EOF" / "BOF" when reach by press PgUp / PgDown

after SET FILTER TO ... dbgotop()

[franco]

Have you tried a temp index. I find set filter to be very slow. I never use set filter when record size more then 100.

Code: Select all

index on (a field ) to rtemp for  TRIM( LOWER( cWorkKeyWord ) ) $ TRIM( LOWER( FORUM->CODE ) ) .OR. ;
                   TRIM( LOWER( cWorkKeyWord ) ) $ TRIM( LOWER( FORUM->BODY ) ) 
go top
Browse wanted fields.
set index to
delete temp index

[AUGE_OHR]

hi

thx for Answer

@dragancesu
Ok, "normal" is to start from TOP

when download Message i do hae a Index and TAG "DUPECHECK"

Code: Select all

cField := "STRZERO(TOPICNO,5)+DTOS(TDATE)+TTIME"

but when have Message from "older" Thread (TOPICNO) i do not "see" them

general it "should" work when INDEX is "just" DTOS(TDATE)+TTIME" ... if i got Date and Time ...
so i use ORDSETFOCUS(0) and begin at BOTTOM with "latest" Message

@Franco
to use a temporary Index seem a good Solution

thx for help