Actually, that is pretty easy to fix. Just create a row in the B table for each request id in the t table that isn't in the b table.
Insert into b426 (c1) select c1 from t426 where c1 not in (select c1 from b426) I am not positive that will work off the top of my head, but it gives you the idea. On Fri, Apr 11, 2008 at 11:50 AM, Dwayne Martin <[EMAIL PROTECTED]> wrote: > I think I tracked down the problem. I just don't know what to do about > it. > > The sql log for creating the view says: > > CREATE VIEW LA_SI_Lab. . . AS SELECT T426.C1,C2. . . WHERE T426.C1 = > B426.C1. > > B426 is the table defining the attachment pool, which we created fairly > recently, probably November 26. > > This means that any records created before November 26 won't have a > corresponding B426 record and won't appear in the view. > > Is there anything that can be done, other than realizing that adding an > attachment pool excludes all previous records from the sql view? > > Dwayne > > > > ***** > > Dear List, > > Yesterday I submitted a problem with a form not having an sql view. It > turned out that there was a bad Diary field, which I deleted. Now I > have an sql view. BUT the view only shows records created since > November 26. > > My form name is "LA:SI_Lab" and its schemaid is 426. > > If I do "select count(*) from T426" I get 8646 > > If I do "select count(*) from la_si_lab" I get 50 > > If I display those 50 records they are all the records created since > November 26. I don't know of anything significant that happened on > November 26. > > I tried changing a field definition to create a new view, but it didn't > help. > > Any ideas? > > (ARS 7.1, RH Linux server, Oracle 10.2 db) > > Dwayne Martin > James Madison University > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
