I posted a message about a problem that I am having and have received several replies. I'd like to throw in something odd that I discovered.
To recap, I have a view that links on one column. This column is the only common column in the pair of table. For most of the rows the data shows up fine however, on some rows the data in one row does NOT show up. The data IS there, when you look at the component tables, and when you dump it out from those tables. It just does not show in a report based on the view - or the view itself. The common, linking column is a client id. The view links a master table with a child table that holds a record of services rendered. The only consistency I see is that if one row of a certain id shows all the data, then all the rows will, and if one is missing all will be. An oddity, which may or may not be significant, is that the data is not completely masked. Rather the first 4 letters in the field show up. The field is a note field. Several messages suggested that this might be database corruption and I should unload and reload the database. Although this will have to wait until tomorrow evening, I was able to do some checking. Pack has no effect. RScope shows nothing wrong with the database. I tried dropping and recreating the view. No help. Weirdest of all, there is another view based on these two tables, with the same linking column, and with that field. In that view the data shows up! Does this still sound like a database corruption? ================================================ 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/
