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"
