I ran into this a while back, and yes, inserting records into the corresponding B table will fix the problem.
On 4/11/08, Brian Goralczyk <[EMAIL PROTECTED]> wrote: > ** > 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" > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
