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"

Reply via email to