Yep, I do the same thing with some deleted flags. rjsjr
ps - There are some applications where a deleted flag makes sense. I have a client that wants to "delete" quotes from one page but still have the display in another. If a quote has never gotten past a certain stage then it can just be deleted from the database otherwise it needs to be marked as deleted so it doesn't show up in one particular screen. One view has all the quotes and another view has all of the ones not marked as deleted. > -----Original Message----- > From: David Corbin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 6:20 AM > To: OJB Users List > Subject: Re: RE-POST - INSERT and SELECT from different "tables" > > > Matthew Baird wrote: > > >1. no > >2. no > > > >#2 custom rowreader might be able to do this. Sounds like a lot > of trouble though. I doubt many people (if anyone) is trying to > do #2 right now, so I wouldn't expect a flurry of help on this. I > can see how it would be helpful, although difficult, to accomplish. > > > > > In my last application, which was not with OJB, I would have a similar > need to #2. Every table had a "Deleted Flag" (don't blame me, I > inherited the data schema). I started off just loading objects with a > suitable where clause. The problem was, when you have A contains B > contains C, and you want to load all the C, you have to look at 3 > DeletedFlags to be sure you've got it right (or change the way Delete > works, which might have made more sense, but that meant deleting an A > would be hitting 15 tables - still would have paid for itself I > suspect), so I created views to match all the tables that only showed > non-Deleted entries. > > >m -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
