Daniel, You could create a display only field on a control form that would run a query against the database returning only the first record or a record count, and then make sure that the field is either not null or doesn't equal 0 before running the rest of the process.
Brian Goralczyk On Thu, Mar 27, 2008 at 2:38 PM, Daniel Weise <[EMAIL PROTECTED]> wrote: > We are running AR System 7.01 connecting to an Oracle 10g database. > We are maintaining our people by importing the records from a view > against our Lawson HR data. We take this and populate a staging table > and then run Active links to look for and populate any changes to the > people records. We repopulate the staging table with fresh data > nightly. I want to verify there are records in the Lawson view before > clearing the staging table. Any ideas what I could do to accomplish > this? > > > _______________________________________________________________________________ > 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"
