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"

Reply via email to