There is a way to check the database's definition for the view to make sure how the view was created. I am not positive of the syntax, but I am sure you can either google it or talk to you DBAs. If the view is not showing everything that is in the table then it has to be in the qualification of the view. HOWEVER; if you are seeing the records in database but not in the user tool, then that would indicate a disconnect between the T and H tables.
Hope that gives you an idea or two to look into. On Fri, Apr 11, 2008 at 11:26 AM, Dwayne Martin <[EMAIL PROTECTED]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

