I've had the goofy 'y' errors as well....but when it happened to us it was a corrupted table. Data fields would come up with those values (whether browsing the table or viewing data through forms) Most recently we discovered the bad table, tried to reload from a backup of the table, without success, as this is a table that holds data only temporarily in certain seasons...so it hasn't been used for several months. Database backups may have been copying this corrupted table for months. I was able to print the structure of the table and we deleted it and redefined it in database designer. Once we reloaded the newly created table everything (including forms that weren't working) worked fine.
I'd love to tell you I know why it happened, but I don't. It's happened to me about three times in more than 15 years of using several versions of Rbase. It's not new to 7.1. I'd just experiment with different fixes, from he easiest onward. 1. Reload Database; 2. If problem still exists, try reloading the form from a backup database or backup copy of the form 3. Delete and replace the objects on the form that contain the scrambled data. Save the new form and see if it works. If not; 4. Check the table(s) these forms reference to see if they've been corrupted...etc. Paula Stuart Community Development Strategies 70 Summer Street Somerville, MA 02143 617-776-3367 617-776-4554 (Fax) 617-388-1331 (Cell) [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Tuesday, June 28, 2005 4:04 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Entry Form Bill: Have you confirmed that your data is not corrupted and that you do not indeed have the characters in question present? You can try: EDIT * from your_file_name WHERE your_where_clause And verify that the problem is with the form and not with the data. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of William Owens Sent: Tuesday, June 28, 2005 2:09 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Entry Form Albert null is set to -0- All the fields are defined as dbedit fields in my form I open form in form desing mode and I'm not sure what you expected me to see. Other fields are defined as dbedit and I only use the property tab to define table and field name. There are no eeps or popup menus in any of my fields. The others come out as blank when I save form without doing any data entry..Just these 4 fields have the y umlaut any other thoughts would be appreciated. Thanks Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Albert Berry Sent: Tuesday, June 28, 2005 12:40 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Entry Form Bill, the y umlaut character is ANSI 0255. Try SET NULL -0- and reopen the form in design mode to see if it changes. Verify any formulae that are on the characters, and then the underlying data set. --- William Owens <[EMAIL PROTECTED]> wrote: > > I am using the latest version of Rbase 7.1 FRC > I have have many fields defined in the form but if I leave the fields blank > and save the form. When I go back into form > 4 of the fields (all defined as text) have what looks like the letter > y with > dots over the Y. I have as many y's as the field length example if > field defined as text 4 I see yyyy with dots over each y? Now this was > working fine last week before upgrade to Final 7.1 release. But > that's not to say it's the Final release. I could have screwed up something > else in the form??? > > > Thanks > > Bill > > 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]
