Do you have differing where clauses in the two views? Could that be the problem?
K Kleinman Zajac <[EMAIL PROTECTED]> wrote: >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/ > __________________________________________________________________ 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/
