populate edittable over 64k (OpenInsight Specific)
At 28 MAR 1999 11:56:59AM Brian Wick wrote:
Any ideas on how to populate an edittable over 64K other than one cell at a time ?
At 28 MAR 1999 05:02PM garygnu@compuserve.com wrote:
I know people some people claim that doing more than one is twice the fun, but trust me, when you do it right, populating one at a time is the best.
garygnu@compuserve.com
At 29 MAR 1999 04:28AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Use Insert_Row to bung in 64K chunks?
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 29 MAR 1999 09:17AM Oystein Reigem wrote:
Brian,
For displaying long lists of data I have successfully tried hierarchical list boxes. But of course one cannot fit all kinds of data into list boxes. Also some people might prefer to do it on a table rather than in a box. (Sorry - just read GG's reply.)
My approach:
- First I run through the data and divide it into K chunks of N items each.
- Then I make a list of K "chunk entries" and display in the list box.
- Then, if the user doubleclicks a "chunk entry", a script explodes the details of the chunk.
- Before exploding the new "chunk entry", the script collapses any already exploded entry, not to overload the list box.
- Oystein -
At 29 MAR 1999 03:55PM Brian Wick wrote:
Andrew,
What is bung.
Just an example:
I have 20 columns each column has 50 characters. (1 row=1000 chars)What is the fastest way to populate 700 rows
At 29 MAR 1999 07:54PM Cameron Revelation wrote:
Bryan,
See the source for POPUP and POPUP_SUB to see how the Popups do it in OpenInsight.
Also see the source for XOQUERY to see how the Client/Server query tool does it in OpenInsight.
Start by making sure you have MAX ROWS set to -1 to allow for ]64k; this is in the edit table properties in the form designer (double click on the edit table, press the More button).
Suggestion: Set the first 32k with the LIST property. Then add 32k at a time using the Send_Message INSERT_ROW like Popup and the Query tool do.
Cameron Purdy
Revelation Software
At 30 MAR 1999 05:59AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Bung=throw
So assemble a big chunk and use insert_row, to insert in large blocks rather than a line at a time.
amcauley@sprezzatura.com
World Leaders in all things RevSoft