Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 5 Jahren, 2 Monaten
Letzter Beitrag:
vor 5 Jahren, 2 Monaten
Beteiligte Autoren:
RichardRose1, Piet van Zanten, Al, Geoff B, Fabrice Harari

Unable to column sort list box linked to table

Startbeitrag von RichardRose1 am 24.03.2013 22:28

The sort and column locators dont appear in the list box columns.

How do I make the list box sort by clicking on the column header?

The table is linked to a MS SQL table as direct access, if I change it to the 100k record limit I get the sort indicators and search locator, but I'm dealing with tables that have in excess of 100k of records.



Hi Richard

the sort functions are available for MEMORY table (loaded by programming) for all columns, and for direct access table ON FILES on the KEY only columns, which explains why they appear when "loaded in memory)

So either add keys on each column where you want the sort, or use a memory table...

Now, I dont know why you want to display a table containing more than 100 000 records, as I've never seen a user who's going to read all that...

A better way of doing that would be to let the user FILTER first the content he really want to see

Best regards

von Fabrice Harari - am 25.03.2013 11:54
I'll build a key for each field then and the reason for needing access to more than 100k of records is becuase for some companies 100k of records is not alot to look for. I do have QBE available but they prefer sorting and scrolling through records, thanks for explaining why though.

von RichardRose1 - am 27.03.2013 19:55
Sounds like Windev browses are file loaded instead of page loaded (as in Clarion) so the performance might be slow.

I had some files in my Clarion app where page loading a multi-million record table was also slow and forcing the users to pre-filter the browse was the only solution that worked, but it worked pretty well!

Might be one of those cases where adopting the "Windev way" is required?

von Geoff B - am 27.03.2013 23:32
Hi Richard,

There's also the option to set "loaded in memory" for a file datasource in the content tab of the table.
In that case the sorting and searching is available for all columns in the table.
Of course this might result in slow loading of the table.


von Piet van Zanten - am 28.03.2013 10:00
Lets say I opt to use options which only work on the 100,000 record restrictions, what would happen if over time the number of records went over 100,000 records, would the system show an error or would it show say 110,000 records without any complaint or warning?

Piet, is there a way to define an in memory table manually? I have a project which involves capturing a lot of data via API's which need to be stored in memory as a number of calculations are carried out on them which would slow up the machine if they had to be stored on disk and then processed from the disk buffers.


von RichardRose1 - am 28.03.2013 20:29
Hi Richard,

Arrays of structures work great.
Look at the ArraySort and ArraySeek functions for arrays of structures.


von Piet van Zanten - am 29.03.2013 12:02
Hello Richard

If the available records exceeds the limit imposed, Windev displays a message to indicate the display is limited to "X records.

From the help:
browsing tables with file loaded in memory. In this case, only a limited number of records is loaded in memory. If the file contains more records than the number defined in the table description, a message is displayed to the user: "There are more than XXX records. Only the first XXX rows will be displayed".


von Al - am 29.03.2013 17:10
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.