Frederick, That worked! Thank you! Thank you! Thank you!
Brian and Mike, thanks for your suggestions, which were similar to Frederick's. Dwayne ---- Original message ---- >Date: Fri, 11 Apr 2008 12:00:43 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: SQL view only showing recent records SOLVED sort of >To: [email protected] > >Oh yes ... Commit afterwards ;) > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W >Sent: Friday, April 11, 2008 11:59 AM >To: [email protected] >Subject: Re: SQL view only showing recent records SOLVED sort of > >Run This > >Insert into B426 (C1) > (Select C1 from T426 Where (Select C1 from B426 Where T426.C1 = >B426.C1) Is NULL); > >Fred > > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Friday, April 11, 2008 11:51 AM >To: [email protected] >Subject: Re: SQL view only showing recent records SOLVED sort of > >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" > >_______________________________________________________________________________ >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"
