Re: sqr check for existence of a file on network drive

[Robert Stojkovic <robert.stojkovic@IO-CONSULTING.COM>]

Allen
That would depend on the type of file you are looking for on the network.
If you are looking for a flat file do an open and check for file status it
was able to open the file.
If you want to know how many rows in the flat file have it start reading the
file in if more than 1 row is process then exit the read and proceeded with
your sqr.  If no rows then exit sqr.

Hope this helps
Robert Stojkovic
robert.stojkovic@io-consulting .com
visit our website www.io-consulting.com
cell 661 857 0350


-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Allen Cunningham
Sent: Tuesday, July 02, 2002 2:29 PM
To: SQR-USERS@list.iex.net
Subject: sqr check for existence of a file on network drive

I have an sqr I want to schedule to run, but only if a file exists on a
network drive, and that file is not empty. I need to find out a way for the
sqr to check if the file exists. Anybody know of any sqr file functions that
will work for this??

ac

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505

This message has been sent using 100% recycled electrons.
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*