MARK all the records from a table

LLOSETI

Hi friends...

does exist any way to select all the registers of a table and set them as Marked (TRUE)?

Something similar to MODIFYALL but MARKALL or something like that...

My issue is the following... I have a very big table. We have a page with two parts, on TOP User can apply filters on different fields.



For a better yield I need to internally use the best Key deppending of the filters used by the user else it can waste lot of time

But the final result MUST be shown always in the same order (using always an specific key)

So my solution is:
- use the right key to by used in the filter
- mark all the records in the filter.
- clear filters
- Show only marked records with the final desired key for the user.

But to put the MARK(TRUE) I have to loop through all table records in the filter... and it takes lot of time as well.


If you ask why I am using these Filter boxes instead of use normal way to filter in Nav it is because some of them reffers to other tables differents of the table linked to the page.

Any proposal?

kriki

Mark is not best for performance.

Did you try to just applying the filters to the table with the setcurrentkey you need to order the records and then doing a CurrPage.Refresh(false) doesn't work?

Otherwise: read your table save the records in a temptable and show that to the user.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]