I have an Edittable defined for Multiple select (see OI article and below).

Val=bitor(Val, DTS_MULTIROW$ + DTS_LARGEDATA$) Record=Val

Works fine. However, is there a way to change the Row Number Buttons on the Edittable to something smaller or aesthetically pleasing.

Also is it true that an Edittable set with "DTS_LARGEDATA$" will be able to handle more than 64K? Is there a limit? Just curious.

Thanks,

Ray

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Hi Ray

I don't know what your largedata$ thingy will do.

_I do know if you have an edittable on a form and you set its row limit to -1 (under the more button in the edittable properties) you can fit more than the default 32K of formatted data. I think the amount is related to the RAM on the PC. I am not sure you can ever stuff more than 64K of data in. I know with the -1 setting, for one table I managed about 700 rows of 10 columns of formatted data (mostly $money). But if the table is bound to a file then it will have the 64K limit that a file record has. At least of unformatted data.

I wrote a table loader to load "pages" of data into my table. It was incredibly convoluted, but I could have as many formatted rows as I wanted that way. If I got really creative I guess I could fold the data through a file table and really have an infinite (within disk space allowance) number of rows. Before the loader or the -1 limit, we could only get 40 rows of formatted data in the edittable. 700 rows instead of 40 rows was worth the effort for my client.

Scott

Ray,

Works fine. However, is there a way to change the Row Number Buttons on the Edittable to something smaller or aesthetically pleasing

It's not possible to change the look and feel of the row buttons on the EditTable. They are basically hardcoded to be 40 pixels wide and look like refugees from the days of Windows 3.x (which of course they are . Neither is it possible to change the 3D grey color to match the rest of the system colors, so you're stuck as is I'm afraid.

Also is it true that an Edittable set with "DTS_LARGEDATA$" will be able to handle more than 64K? Is there a limit?

As Scott mentioned setting the Row Limit to -1 sets this style for you. Without this an EditTable is limited to about 64K's worth of data across ALL it's columns and rows, and a column's DATA length setting in the EditTable properties plays a big roll in this. To get more rows you need to reduce the data length in each column as much as possible. Memory is allocated according to the column data length specified, not the length of the data put in the actual column's cell. So if you say a column has a data length of 20 chars then 20 chars worth of memory is used, regardless of if you only put data in that is chars in length.

If you set the row limit to -1 in the Edit Table properties it will use virtual memory to store the data, which is then only theoretically limited by the amount of memory available to Windows in your system.

However, each edit table CELL may only hold 999 characters regardless of the memory setting so there are still limits.

The Sprezzatura Group

World leaders in all things RevSoft

Ray,

To make our edittable buttons look a "little" nicer, you can use this command during your window create event:

Send_Message(Control, "COLWIDTH", -1, 26)

This will make the row button look a bit more square rather than so rectangular.

ftomeo@srpcs.com

SRP Computer Solutions

I've been doing a bit of experimenting with large edit tables lately.

I've found the limit with the -1 parameter set to be about 16Mb.

As you approach this point the slider bar on the right hand side of the table no longer allows you to drag to the end of the data. When you exceed 16Mb the system actually crashes with variable exceeds maximum length. (Sorry can't remember the complete message, but it was a system type message)

However, each edit table CELL may only hold 999 characters regardless of the memory setting so there are still limits.

Does this mean that AREV tables, containing AMV's with value sizes ] 999 get mutilated when handled through OI EDITTABLES ???

Wilhelm

One would assume so if you try and save data that's been truncated. I expect the edit table won't both storing data that it cannot display.

The Sprezzatura Group

World leaders in all things RevSoft

Paul,

It's hardly surprising that it falls over - 16MB of memory was a HUGE amount back in the early 90's when the Edit Table (DataTable v2) was written.

I've also seen it having trouble drawing itself in high resolution screens too. In fact I'm sure you guys have had that problem as well…

The Sprezzatura Group

World leaders in all things RevSoft

Frank,

Nice!

I'm sure I played with the -1 setting years ago and didn't get anywhere, or maybe that was trying to play with column headers instead…

The Sprezzatura Group

World leaders in all things RevSoft

Scott,

Well I got the "largedata thingy" from looking at an example found on this site. It discussed how to do multiple select and noted that after you "destroy" and "re-create" your EditTable that it will be able to handle more than 64K of data. I can't remember where I got the item from since I printed it up sometime ago and just found it. I do like paper .

Hopefully, with the -1 or using the "largedata thingy", I won't have to do anymore programming than I have to .

Ray

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Mr. Sprezz:

However, each edit table CELL may only hold 999 characters regardless of the memory setting so there are still limits.

Great Scott, what would you put into such a cell – 999 characters.

Ray

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Frank,

Send_Message(Control, "COLWIDTH", -1, 26)

Neato. It does make the Edittable look better. Another Excellent Suggestions from you folks at SRP!

Hey where's Don ?

Thanks,

Ray

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Paul,

Just curious, but how many rows did you have for 16M? It had to be bunches and bunches.

I seriously doubt that we would ever come close to that in our application. I would tell our users to get a life if that ever happened. It would be nice however to have a new Edittable that's more up-to-date.

It would be nice also to have a new form designer that isn't limited to the 115 controls. BTW have you started working on the new form designer yet. Since you volunteered, I think that a bunch of us are waiting. If you don't have time for that maybe a new System Editor would be easier.

Thanks in advance .

Ray

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Ray..

Text information associated with MV's, of course. For example, employee incidents:

Date Of Incident, Incident Type, and Text / Notes. I do this in one of my applications. So…. I check to make sure that the text entered in the call to ZOOM doesn't exceed 999 characters.

Don Miller

C3 Inc.

"Converting AREV Applications to OpenInsight The "good news" There are many aspects of your Advanced Revelation application that will translate into OpenInsight. Here's what you can convert: data files, dictionaries, indexes, and the basic logic of your programs - and the best news: you don't have to re-enter your data… except AMV's with value sizes ] 999.

Is this a bug or a feature?

Wilhelm

Ray,

I decided to make you wait because this technique is exampled in your Promoted_Create_Events routine.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

The Don,

Yes I saw this used, but didn't know what it did. Heck it was working , what's there to know .

Discovering one thing at a time based on my need of the moment which are many. Thanks,

Ray

Actually, I have done the system editor (it slices, dices and chops)

I've actually written a complete TCL replacement that has just about all the Arev functionality but with extra enhancements. Unfortunately the company I work for owns it so I can't distribute it.

As for the 16Mb table. It was actually the result of a listing of a file, as in LIST FILENAME FIELDNAME etc, with lots of records. The reason I used the edittable was so that the headings would scroll left and right when you moved across the screen. It works really well. As for the number of rows, it varied depending of the length of the line (I'm dynamically sizing the line length) but a figure of around 25,000 comes to mind.

Paul,

Actually, I have done the system editor (it slices, dices and chops)

Gee can your system editor also handle larger records say in the 64K range? ;) What are the other neat features (…drooling….) Tell me what kind of a human being would covet over a System Editor. Most people wouldn't understand such longing desire . They are normal of course.

I've actually written a complete TCL replacement that has just about all the Arev functionality but with extra enhancements. Unfortunately the company I work for owns it so I can't distribute it.

Wow, that's quite an accomplishment. No doubt many AREV developers would love to have such a useful tool.

As for the 16Mb table. It was actually the result of a listing of a file, as in LIST FILENAME FIELDNAME etc, with lots of records.

Gee, I never thought of stuffing the output from a LIST statement into an Edittable. How cleaver. How do you do that?

Oh yes, now that you seem to have excess time on your hand, we're all waiting for the New FORM DESIGNER. Do you think you could have it before Thanksgiving?

Tally ho,

Ray

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Gee can your system editor also handle larger records say in the 64K range? ;)

]]]]] Yes, It can edit DOS records up to about 16Mb. (Its still a bit clunky though. I've got to improve it) Rev records of course still can only do 64K. You can't save a record thats any bigger so there's no point.

Tell me what kind of a human being would covet over a System Editor. Most people wouldn't understand such longing desire . They are normal of course.

]]]]An evil sort of person of course!

(How did you get the previous posting into italics?)

As for the 16Mb table. It was actually the result of a listing of a file, as in LIST FILENAME FIELDNAME etc, with lots of records.

Gee, I never thought of stuffing the output from a LIST statement into an Edittable. How cleaver. How do you do that?

]]]There are actually a few steps to it. You start with capturing the RLIST output code in the RLIST_OUT record. Then programatically modify that so that all the output is redirected to a subroutine that handles the output & populating of an edittable (or editbox). Then recompile on the fly and execute. Its all seamless. Looks exactly like Arev list format.

Oh yes, now that you seem to have excess time on your hand, we're all waiting for the New FORM DESIGNER. Do you think you could have it before Thanksgiving?

]]]]If I start this morning I'll have nothing to do in the afternoon!

(I'd better watch it, I think I'm painting myself into a corner here. Some people may actually think I'm going to do this. I am thinking about how to though….)

Paul,

(How did you get the previous posting into italics?)

Don't you see the italics button on your browser …. just kidding. Making text italics is simple. For example, to do this, you would put the text between "brackets" (no quotes), e.g.,

""to do this""

starts italics; ends italics. and make things bolds. You need the "brackets."

If I start this morning I'll have nothing to do in the afternoon!…Some people may actually think I'm going to do this…..

What do you mean "think I'm going to do this." We know that anyone who runs an Rlist of 16M or 25,000 row through an Edittable has plenty of time and talent. The only contribution I can make is that I know you gonna to need to use some "CONTROLS" and "EVENTS".

Best wishes and please keep us all inform. You have 62 days until Thanksgiving.

Ray

Opps my example messed up.

to do this

Put the above example text in between matching "brackets" – text…text….text– and it will become italized (sp).

Ray,

I always put square brackets around each individual html code.

Like

()each individual() (pretend the parantheses are square brackets). Isn't that necessary? - Oystein - </QUOTE> —- === At 21 SEP 2001 12:29PM Ray Chan wrote: === <QUOTE>Oystein, Initially I thought so too, but upon experimentation, I found that just putting the "brackets" around the text worked. (is adequate) Ray </QUOTE> —- === At 21 SEP 2001 01:48PM Oystein Reigem wrote: === <QUOTE>Ray, Do you even think we could make do with a single pair of brackets around the whole discussion list? Sorry. The news about the 32bit version of OI was just too exciting! - Oystein - </QUOTE> —- === At 21 SEP 2001 03:16PM rayc@symmetryinfo.com wrote: === <QUOTE>Oystein, The news about the 32bit version of OI was just too exciting! Yes, I was a bit startled when I read the announcement. I guess I was mostly surprised at the progress made. Unlike earlier "cream puff" statements, the intent and the results are there! It is like Julius Ceasers when he said, "I came, I saw, and I conquered." In other words, we are beyond "hoping" and "planning". We may soon have a working 32-bit OI to play with and deloy. Let me get my "quack" and make a toast. We wish RTI all the best luck and resources on this exciting direction and that all developers provide support and assistance when needed and that the product will be feature-rich and make people say WOW. Ray P.S. Of course, it must get rid of the memory limitations we encountered today rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)" Symmetry Info Ray Chan ~ Symmetry Info </QUOTE> —- === At 22 SEP 2001 11:46AM Donald Bakke wrote: === <QUOTE>It is like Julius Ceasers when he said, "I came, I saw, and I conquered." I thought this quote came from Alexander the Great. dbakke@srpcs.com SRP Computer Solutions, Inc. </QUOTE> —- === At 22 SEP 2001 12:17PM Wilhelm Schmitt wrote: === <QUOTE>Hi Don, the important thing is not so much, who said it, but the fact that there is a new conquest to celebrate at Revelation. :) Congratulations ! Wilhelm veni, vidi, vici. These words, which Suetonius tells us were carried on a banner in a triumphal procession of Julius Caesar (Divus Iulius 37), can serve as a starting-point for an analysis of rhetorical figures and sentence-construction. "I came, I saw, I conquered." from: http://web.gc.cuny.edu/dept/class/rhetfig.htm </QUOTE> —- === At 22 SEP 2001 01:21PM The Sprezzatura Group wrote: === <QUOTE>Pedants 'r' us… (expansion not negation of Wilhelm's comments) Vini Vidi Vici (I came I saw I conquered) is Latin. Alexander whilst Macedonian, spoke Greek. Thus, Caesar it is who allegedly said this though only quoted by Shakespeare in "Julius Caesar" after Caesar had crossed the Rubicon. The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 24 SEP 2001 02:19PM The Sprezzatura Group wrote: === <QUOTE>Fractured Latin… Vini vidi vacuum I came, I saw, It sucked Vini vidi visa I came, I saw, I bought Vini vidi venav I came, I saw, I forgot to assign a variable Vini vidi visa I came, I saw, I bought Vini vidi vista I came, I saw, it had a nice view Vini vidi veggie I came, I saw, I planted Vini vidi velcro I came, I saw, I stuck around Vini vidi viola I came, I saw, I played Vini vidi vide I came, I saw, hey! look over there! The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 01 OCT 2001 04:22PM Don Miller - C3 Inc. wrote: === <QUOTE>How about… Vini, vidi, viagra I came, I saw, I fed around Don </QUOTE> —- === At 02 OCT 2001 06:20AM Oystein Reigem wrote: === <QUOTE>Don, You spelled it with the wrong number of asterisks. It's a four-letter word, you know. Come to think of it - in the new, 32-bit world all words will four-letter words. Which of course should be phrased: Innn theh neew 32bt wrld aall wrds will beee four letr wrds. - Oysn - </QUOTE> View this thread on the forum...