It seems to be related to a form variable with the same name as the table column (both named end1). I deleted the form variable. Now the zero no longer pops up on data entry.
Dayle Coxen Office of Maintenance (850) 410-5635 Please note: e-mail may be subject to public disclosure. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, March 22, 2012 10:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Zero pops up during Form field entry You're welcome. At least we know it was not an artifact from the conversion. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle Sent: Thursday, March 22, 2012 9:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Zero pops up during Form field entry Dennis - I deleted the field from the form and re-added it. I still get the zero appended to any numeric typed in. Thanks for your response. Dayle Coxen Office of Maintenance (850) 410-5635 Please note: e-mail may be subject to public disclosure. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, March 22, 2012 9:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Zero pops up during Form field entry Did you try dropping the field from the form and recreating it manually? Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle Sent: Thursday, March 22, 2012 8:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Zero pops up during Form field entry Karen - I just double-checked under "DB Edit Properties" window "Effects" tab and both Format Mask and Default Value are empty. Thank you for your response. Dayle Coxen Florida DOT (850) 410-5635 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, March 22, 2012 9:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Zero pops up during Form field entry I know you said you checked for a default value, but did you check "format mask"? Sounds like an old 6.5 format mask that prevented alpha from being entered into a numeric field. Karen In a message dated 3/22/2012 7:29:48 AM Central Daylight Time, [email protected] writes: I converted a entry form from 6.5++ to 9.1 (Build 9.1.5.20317) The form has a series of fields: end1, end2 (ending readings) where we enter the mileage used for a piece of equipment. This is not an external form. When you tab to one of the ending reading fields it is empty. But the problem occurs when you type the first numeric character. A zero pops up in the low order position creating a 2 digit number ending in zero. If you type a 5 you get 50, type a 3 you get 30 etc. The user then has to delete the unwanted zero(s). The form field has no "Default Value" in the "DB Edit Properties" under "Effects tab". The ending reading columns (end1, end2) are defined in the table as REAL. There is a Rule on the column end1: (rda3.end1 IS NULL) OR (rda3.end1 GE rda3.begeqp). This is to ensure that if a reading is entered, it is greater than the beginning reading. In the old 6.5 system the ending reading could be entered without the low order zero popping up. Any suggestions?
