Another thing to look for -
One of my users kept unknowingly inserting high bit ASCII characters (smiley faces, graphic text characters, etc.) into columns when entering records with a columnar Edit. The high bit ASCII characters were invisible in R:Base but when the data was exported to any other program, like Excel, they became apparent. Since the columns now contained the invisible character, the rows wouldn't appear if a query was based on an "equals" operator, but sometimes would when a "like" operator was used. RScope, Reload, and Pack had no effect because there was NO corruption, just unreadable data. The invisible data, however, would export using Gateway or Unload as ASCII. I discovered after a time that this user had her display set to large fonts. When we reduced the font size, the problem seemed to go away. Often users like to increase their screen font size, especially when their displays are set to very high resolutions. Or you might just have corrupt screen fonts on your system. This might be an area for you to check. Good luck! Tony Anthony Schmidt, JD President The Computery Ltd. One East Main Street Bay Shore, NY 11706 631-665-8100 Voice 631-969-5988 FAX http://www.computeryltd.com |---------+----------------------------> | | owner-rbase-l@son| | | etmail.com | | | | | | 04/18/2002 07:24 | | | PM | | | Please respond to| | | rbase-l | | | | |---------+----------------------------> >---------------------------------------------------------------------------------------------------------------------------------------------| | | | To: <[EMAIL PROTECTED]> | | cc: (bcc: Anthony Schmidt/BayShore/SGU_LN) | | Subject: RE: Re: Direct Insert/Edit in a Table "Loses" Record A (RBWIN65++ Latest Build) | >---------------------------------------------------------------------------------------------------------------------------------------------| I tried on my database and no problems. You might have a defective program or disk. Try reloading the program. Dan G -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Sent: Thursday, April 18, 2002 4:08 PM To: [EMAIL PROTECTED] Subject: RE: Re: Direct Insert/Edit in a Table "Loses" Record A (RBWIN65++ Latest Build) Also, the example shown here.... does not fail in 6.5. Possibly it is a setting that is different, I will check. AutoCom is OFF on both 6.5++ and 6.5. At 06:41 PM 4/18/2002 -0400, you wrote: >In the case I had, Pack did not make the rows appear. > >Try it on the concomp database. >1. create TestTable with two colums, columnOne text 8 , ColumnTwo, Text 8 >2. opening the table to browse it gets the usual "No Rows in Table, insert >a Null Row?" >3. Answer Yes, type in both fields, >4. Hit f2 to insert blank row, type in both fields, repeat this as many >times as you like >5. Close the table, >6. Reopen to browse data, and there is none. > > > >At 05:53 PM 4/18/2002 -0400, you wrote: >>IF packing the database causes the records to appear, that means that the >>indexes were not updated during the adds. PACK KEYS would do the same thing. >> >> >>"Sami Aaron" <[EMAIL PROTECTED]> wrote: >> >> >I've run into this on occasion and reported it as a bug, but RBTI wasn't >> >able to replicate it ... >> > >> >Just pack the database and the missing rows should appear (like magic?) >> > >> >I never use the browser to insert or delete records - just for viewing and >> >editing existing fields. Can't wait for the version 7 browser! >> > >> >Sami >> > >> >----- Original Message ----- >> >From: "J. Stephen Wills" <[EMAIL PROTECTED]> >> >To: "RBase List Server" <[EMAIL PROTECTED]> >> >Sent: Thursday, April 18, 2002 2:36 PM >> >Subject: Direct Insert/Edit in a Table "Loses" Record (RBWIN65++ Latest >> >Build) >> > >> > >> >> Okay, I'm sure it's something I don't know, but, it's making me feel >> >> light-headed. I open a table from the Object Browser. Then [F4], then >> >> [F2]. Add record, [F8] to go to NEXT (rational skeptic, me), record >> shows >> >> in grid. Close window, Open same table, "POOF" record is gone. >> >> >> >> I saw this last Friday|Monday and I worked around it by "SET MULTI off", >> >but >> >> this makes no sense to me. >> >> >> >> TIA, >> >> Steve in Memphis >> >> >> >> ================================================ >> >> TO SEE MESSAGE POSTING GUIDELINES: >> >> Send a plain text email to [EMAIL PROTECTED] >> >> In the message body, put just two words: INTRO rbase-l >> >> ================================================ >> >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> >> In the message body, put just two words: UNSUBSCRIBE rbase-l >> >> ================================================ >> >> TO SEARCH ARCHIVES: >> >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >> >> >> >> > >> > >> >================================================ >> >TO SEE MESSAGE POSTING GUIDELINES: >> >Send a plain text email to [EMAIL PROTECTED] >> >In the message body, put just two words: INTRO rbase-l >> >================================================ >> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> >In the message body, put just two words: UNSUBSCRIBE rbase-l >> >================================================ >> >TO SEARCH ARCHIVES: >> >http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> > >> >> >>__________________________________________________________________ >>Your favorite stores, helpful shopping tools and great gift ideas. >>Experience the convenience of buying online with Shop@Netscape! >>http://shopnow.netscape.com/ >> >>Get your own FREE, personal Netscape Mail account today at >>http://webmail.netscape.com/ >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
