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
