Also, if you are creating temporary tables on the "before design: and deleting them on the "on exit" EEP, the tables will no longer be there when you run the form from the designer, exit the form and return to the designer. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax Visit us at www.vtgonline.com <http://www.vtgonline.com/> _____
From: [email protected] [mailto:[email protected]] On Behalf Of Tom Frederick Sent: Wednesday, June 29, 2011 5:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBWin 7.6 - Controls on a form limit Two items: 1. You hitting your system's memory limits? 2. Do all the controls go to the same table or are they spread over multiple tables and views? Check for duplicate column names. (Same column names in a Table and a View) or (same column name in two different tables) = duplicates if used in the same form or report. It forced me to learn about using aliases in views. Sounds like you have 40 items a page. I had similar issues with an Enhanced tab with lots of pages with dense info entry. All those lookups need to get loaded when you start up. Ended up breaking it up into a Form with a menu system using Bit and Speed buttons. Each menu button has its own specific Forms with about 40 items each and is isolated from the others. Load 40 items compared to 650 at one time. Lot less memory, better control over names, unneeded variables cleared at form exit, and easier to track what was going on. Runs quick. Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Lena Dammstrom Sent: Wednesday, June 29, 2011 3:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RBWin 7.6 - Controls on a form limit Hi, I am working with RBase Win 7.6 and I have been creating a form with an Enhanced tab control with 14 pages. Within all those pages/tabs, I have about 650 controls. Labels, var labels, bit buttons, var Lookup Combo boxes, var edit, var lookup ListViews etc. I've been noticing lately as I've been adding on more controls, while in design mode; things are not acting as usual. Such as after I run form in design mode and exit the running of the form via a button, I get an error "List Index out of Bounds ###". The ### changes from 648, 649 . 659, 660. If I take one control off the form (I think any kind of control, button, listview); I can stop the error from happening. Running form not directly from design mode, I do not get the error message. After running form via design mode: When back in design mode, and I save the form, this "save" icon does not always gray out (save completed) Also when I click on a control (again in design mode), it does not update the status lower bar that shows the controls attributes (variable, width, height.) Have I reached a per form limit of some kind? Total number of controls per form? Total number of tabs/pages per tab control? Or is there something else that is causing my form to act strangely in while in design mode??? Any tips - clues would be greatly appreciated! Regards, Lena QMI Security Solutions X1037
