My vote would be to use the variable form. I use "on exit" EEPs on each field in variable forms to check data as it is entered. Dong this allows the data to get into the database as quickly as possible for real time use while ensuring some degree of data integrity.
Regards, David Fitts -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Sunday, October 03, 2010 8:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Very Basic Application Data-Entry Form Question All: SETUP: Volunteers perform twice-daily property surveys in a large Association property; recording observations to 40+ possible fields on hand recorders; transcribing to Excel spreadsheet with over 95K rows spanning five years. A subset of columns reliably receive data on each row; but input to the majority of columns is highly variable. This spreadsheet logically represents a 'view'; a concatenation of eight normalized tables in the R:Base schema we've cooked up. A defined set of post-processing steps is performed on the Excel data within Excel before .... ...the Excel data is successfully 'gateway'd' into a single R:Base (v8.0 latest release) table without difficulty. Rudimentary '.rmd' file inquiries at the R:Prompt satisfy immediate needs, but R:Base has created a thirst for more. It's application time. I need to eliminate the Excel step and give the property manager an interface to mash on. QUESTION: Would I best: a) Use a variable form to enter a single row of observations, performing post-processing of variable values into normalized tables on a per-row basis in an On-Exit EEP, or: b) Use dbedit controls to enter daily observations into an 'intermediate holding' table for cursor-managed, batched post-processing into the database, after which the holding table is cleared for re-use? All appreciation, bruce chitiea safesectors, inc. --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
