Page 1 of 1

SET FILTER TO !DELETED()

Posted: Thu Sep 01, 2022 12:13 am
by AUGE_OHR
hi,

i notice when use

Code: Select all

SET FILTER TO !DELETED()
it does slow down BROWSE extrem :shock:

can someone confirm it or what do i miss :?:

Re: SET FILTER TO !DELETED()

Posted: Thu Sep 01, 2022 5:32 am
by andyglezl

Re: SET FILTER TO !DELETED()

Posted: Thu Sep 01, 2022 6:16 am
by AUGE_OHR
hi Andy,
andyglezl wrote: Thu Sep 01, 2022 5:32 am Jimmy did you see this?
https://www.hmgforum.com/viewtopic.php?p=45852#p45852
to "transfer" Record into Array is a Option but i´m not sure if !DELETED() will make a Difference.

---

i normal use !DELETED() in Index, while have to lot of DELETE in a Day Work which slow down.
but under HMG there is a big Difference when use !DELETED() in FILTER which i have not seen before.

while "phpBB Forum Reader" is "read only" there are no DELETED() Record and i have remove it from FILTER

now i have learn that !DELETED() is not a Option for HMG

thx for help

Re: SET FILTER TO !DELETED()

Posted: Thu Sep 01, 2022 8:08 am
by AUGE_OHR
hi Andy,

when read that Thread where you point to i got a Idea / Question :
it it possible to build a Tree this Way :idea:

i do have Index
STRZERO(TOPICNO,5)+DTOS(TDATE)+TTIME
from all with same TOPICNO i want Tree-Node
but TOPICNO can be > 42000 ...

while i can "see" only Part of hole Tree the Idea is to "fill" it "dynamic" ...

Re: SET FILTER TO !DELETED()

Posted: Thu Sep 01, 2022 1:26 pm
by andyglezl
No estoy seguro si entendí tu pregunta.
Puedes ver algo del Tree aquí...
*---------------------------------------------------------------
I'm not sure if I understood your question.
You can see some of the Tree here...

https://hmgforum.com/viewtopic.php?p=36243#p36243

Re: SET FILTER TO !DELETED()

Posted: Thu Sep 01, 2022 6:59 pm
by dragancesu
I'm not sure I understood your question

1. set filter to !deleted() is SET DELETED ON , this command hide deleted records

2. in this case STR[ZERO](TOPICNO,5)+DTOS(TDATE)+TTIME look https://vivaclipper.wordpress.com/2014/01/19/str/

Re: SET FILTER TO !DELETED()

Posted: Fri Sep 02, 2022 8:41 pm
by AUGE_OHR
hi Serge,
dragancesu wrote: Thu Sep 01, 2022 6:59 pm 1. set filter to !deleted() is SET DELETED ON , this command hide deleted records
this is right

but Index "does not know" deleted() so IHMO they are in Index
they will be "skipped" when use SET DELETED ON

when have !DELETED() in Index you will not "skip" Record which can be a lot during a Day
i do use these Technic when "edit" a Record to have a "Backup" of "old Data"

---

dragancesu wrote: Thu Sep 01, 2022 6:59 pm 2. in this case STR[ZERO](TOPICNO,5)+DTOS(TDATE)+TTIME
it is a different Idea

i have use that Index Expression for "DUPECHECK" but when got "new" Message to "old" Thread i do not "see" it
i have to change Index TAG, by click on Column Header, and use TAG "MSGDATE" which does not include STRZERO(TOPICNO,5)

now the Idea / Question was to build a TREE to display NODE of TOPICNO ...
or use Listview-Group like Outlook instead of BROWSE

but it must be "dynamic" while add "one-by-one" take too much Time

is there any Sample which "dynamic" build what i can "see" on Screen :?: