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"

