Page 1 of 1
BROWSE / FILTER / PgUp
Posted: Sun Oct 30, 2022 1:30 pm
by 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
Re: BROWSE / FILTER / PgUp
Posted: Mon Oct 31, 2022 12:03 pm
by dragancesu
does BROWSE / GRID have a Solution to show "EOF" / "BOF" when reach by press PgUp / PgDown
after SET FILTER TO ... dbgotop()
Re: BROWSE / FILTER / PgUp
Posted: Mon Oct 31, 2022 3:24 pm
by 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
Re: BROWSE / FILTER / PgUp
Posted: Tue Nov 01, 2022 12:13 am
by 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