[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== populate edittable over 64k (OpenInsight Specific) ====
=== At 28 MAR 1999 11:56:59AM Brian Wick wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Any ideas on how to populate an edittable over 64K other than one cell at a time ?
</QUOTE>
----

=== At 28 MAR 1999 05:02PM garygnu@compuserve.com wrote:  ===

<QUOTE>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

[img]http://ourworld.compuserve.com/homepages/garygnu/Graphics/gnu-head-sm.jpg[/img]

</QUOTE>

----

=== 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:  ===

<QUOTE>Use Insert_Row to bung in 64K chunks?



amcauley@sprezzatura.com 

[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]





</QUOTE>

----

=== At 29 MAR 1999 09:17AM Oystein Reigem wrote:  ===

<QUOTE>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 -



</QUOTE>

----

=== At 29 MAR 1999 03:55PM Brian Wick wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 29 MAR 1999 07:54PM Cameron Revelation wrote:  ===

<QUOTE>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

</QUOTE>

----

=== 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:  ===

<QUOTE>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 

[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]





</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=328F889AFBD4CD868525674200579D88|View this thread on the  forum...]]