pcsoft.us.windevCopyright 2026, PC SOFT13 Feb 2015 19:07:00 Z13 Feb 2015 11:59:00 ZHi, I`m come to WinDev from the Clarion language and have a couple of questions. In clarion we could have a "page loaded table" out of the box, this table object only load as many lines into the table that there are place for on the screen initially (30 as an example). When I press next-page/Previous page arrow up/Down the table object (browse in Clarion) loads the next 30 records, the cool thing about this is that if my table actually contains 1 million records it`s fast to load "all" anyhow. I tried the memory table with a limit of 50, it`s fast as hell - but - it only loads 50 records, thats it, so I cant do a page-down and load the next 50 records making the limit feature on a mem-table pretty useless? I`m moving over "old Clarion app users" to my new windev app, but I ran into some problems.: 1. Using a modern approach (XML) to move data I discovered that the native driver do not handle large XML files ~40 to 120Mb, Here WinDev have a problem. (Going to report this to PCSoft) - So I had to make a split large file class adding Header (if not first part) and end part of xml to each smaller split-file (¨17 Mb) This worked but I had to analyze each XML file and write extra code. 2. Of my customers, electricians tends to have minimum 80 000 products, this slows down table loading pretty much as I do every time a user click the [Search] button - Here page-loaded table would help a lot. I know I`m not the only one coding in WinDev that comes from Clarion, how are you solving the "Page loaded browse", without coding yourself to death? Fun fact is that entity framework, .NET do not seem to have this obvious functionality in their toolbag eighter ;) Cheers Tor-Bjarne30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50473/read.awp13 Feb 2015 19:07:00 ZHi Fabrice, Your are right again, I will try this first :) Cheers Tor-Bjarnehttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50473/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50473/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50460/read.awp13 Feb 2015 13:55:00 ZHi Again I do not know if you can switch from meory to file by code, as I've never tried... But a simple copy and paste of…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50460/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50460/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50451/read.awp13 Feb 2015 12:53:00 ZHi thank you DerekT, I will consider this ;) Cheers Tor-Bjarnehttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50451/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50451/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50450/read.awp13 Feb 2015 12:51:00 ZQuote In general, nobody is going to look at 80.000 lines in detail except for an export or so. Hi Peter I do agree - bu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50450/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50450/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50449/read.awp13 Feb 2015 12:41:00 ZTor-Bjarne Different approach required maybe. I have found that using classes and arrays is much faster for loading as mos…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50449/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50449/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50448/read.awp13 Feb 2015 12:39:00 ZHi Fabrice - Your save the day again! A quick follow up question. - Can I switch on/of query-memory/Default mode table with c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50448/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50448/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50447/read.awp13 Feb 2015 12:37:00 ZHey TB, Have been requesting such functionality (page based grids -> loading of the grid by page) since V7.5 as I have seen a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50447/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50447/read.awpWinDev - Page loaded tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50446/read.awp13 Feb 2015 12:30:00 ZHi Tor-Bjarne, for your table, the behavior you are describing is the same as creating a windev table linked directly to the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50446/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50445-windev-page-loaded-table-50446/read.awpWinDev - Page loaded table