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

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

Hi Jim - Thanks for the suggestion, I will try that.

ac

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


Let #FileExists = exists($File_Path_And_Name)

if #FileExists = zero after the call the file exists.

Jim Womeldorf
Programmer/Analyst
Fastenal Company
jwomeldo@fastenal.com
(507) 453-8250


-----Original Message-----
From: Allen Cunningham [mailto:allen.cunningham@SONOMA.EDU]
Sent: Tuesday, July 02, 2002 4: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.
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*