I still prefer constraints as the primary validation of data integrity. If using a form for validations, I use a variable only form and when everything meets the constraints of the main table, I will insert the row.
--- Dennis Fleming <[EMAIL PROTECTED]> wrote: > This may be on the conference CD (so I owe bundle up) but I finally have > had a chance to forge ahead on my RB7 conversion. The RBT-list shows that > updates and enhancements are still coming at a feverish pace and that's good. > > Let me start with a few general questions. > > 1. I have moved virtual all of my code in snippets to objects in the Design > Menu Bar option. It's clean, sometimes redundant, but certainly makes > debugging easier. Are there any "tilt" or performance issues to worry > about? I realize that it all goes into file 4 and I'm interested in any > short or long term pros and cons. > > 2. It looks like all forms and reports take a 32kb block in File 4. I like > having a different form running various reports and program options. > Although it seems wasteful, I have a different form running each option. At > about 200+ forms and reports that would make File 4 about 7mb. Again, any > concerns for a multi user network app? I understand that many folks have > giga byte applications, but that's File 2. > > 3. And LBNL (for this email) I have moved a lot more data validation into > my forms and it would seem that I can remove a "shipload" of constraints. I > noticed that at some of my customers where some tables have Not Null > constraints on many columns, it seems prudent to do a little clean up and > free up some overhead in File 3 processing. Any suggestions here appreciated. > > TIA, > > Dennis > ***** > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Mobile: 570 351-5290 > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
