Thanks, Frederick, but my form is a "Regular" form, not a join, and the view is the SQL view automatically created when the form is saved.
Dwayne ---- Original message ---- >Date: Fri, 11 Apr 2008 11:19:49 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: SQL view only showing recent records >To: [email protected] > >If I remember correctly your view joined a couple of tables. Are there >corresponding rows in the joined (H and/or B) tables? > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Friday, April 11, 2008 11:16 AM >To: [email protected] >Subject: SQL view only showing recent records > >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"

