[[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]]
==== Edit Table Properties. (OpenInsight Specific) ====
=== At 19 APR 2001 10:24:46PM Barry Stevens wrote: ===
{{tag>"OpenInsight Specific"}}
Edit Table Properties.
Does the "Data Length" have any bearing on how much data can be loaded into each Column.
I have Row Limit set to -1.
I can load 550 rows but not 595 (only shows 13)
TIA
Barry
----
=== At 19 APR 2001 11:03PM Donald Bakke wrote: ===
Barry,
I believe it affects how much you can stuff into the edittable via a PROPERTY. However, using the Send_Message(Edittable, "INSERT") approach shouldn't have any problems.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 20 APR 2001 04:46AM Barry Stevens wrote: ===
Thanks Don.
There still is a 64k limit, at least for Data Bound windows, I assume.
Barry
----
=== At 20 APR 2001 09:16AM Donald Bakke wrote: ===
Correct. I assumed that since you used -1 that this isn't databound.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 20 APR 2001 09:17AM Don Miller - C3 Inc. wrote: ===
Barry..
The Data Length parameter DOES impact memory usage in a data table. I always set the data length to what I want to show. Typically, I use dialog boxes to enter data into the row involved rather than having a user enter data into the table directly. Mostly, I don't want to have a lot of code hooked to each field in the table with all the manipulation necessary to make this work easily. Instead, I allow for a double-click or pushbutton to change / add data or delete data. The -1 parameter for maximum rows will help. I'm not sure whether the 64K limit applies to the table as a whole or to each thing that makes up the table. For example, I have a data-table that displays 1 real field and all the rest are symbolics. In this case, I have displayed in excess of 5,000 items without trouble. Nobody said that it is efficient to do this given the overhead of re-calculation of symbolics. Typically when I populate the table, I don't display it until the amount on the screen has been calculated.
HTH
Don Miller
C3 Inc.
----
=== At 21 APR 2001 01:00AM Barry Stevens wrote: ===
Don
"I always set the data length to what I want to show".
How do you do that.
Barry
----
=== At 21 APR 2001 12:13PM Don Miller - C3 Inc. wrote: ===
Barry..
When you are working inside an edit table, there are some parameters at the lower left-hand corner. They are labeled Width and Data Length. The width is in pixels for the display the data length is how many characters. The documentation for this says:
"Sets the maximum number of characters to display. Data length is measured in number of characters." This is where I do this.
HTH
Don Miller
----
=== At 22 APR 2001 07:44PM Barry Stevens wrote: ===
Sorry, I was reading into your orig reply that you did it dynamically.
Barry
----
=== At 11 MAY 2003 11:19AM S Botes wrote: ===
I have also noted that the insert message used with an edit table will actually truncate data at the length specified. It just disappears...
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=FF5DB6313B7C91F685256A34000D410D|View this thread on the forum...]]