Re: [sqr-users] Running SQR's from Textpad

["Jamie Harris" <JHarris@frederick.edu>]

I do the same thing in my editor (TSE Pro).  

I have a dos batch file that gets called which removes
"c:\temp\sqr.pdf", then runs the SQR to create that .pdf file then use
the windows "start" command to make the .pdf file open.  

It works great, the only problem is that I must remember to close the
.pdf before I try to run the SQR again because Acrobat locks the file as
read-only if it's open. :)


-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> wardd@mail.uww.edu 7/25/2003 9:46:07 AM >>>
One option which I have found pretty slick is submitting a sqr from
within 
an edit session if using Textpad(although other editors probably also
have 
this capability).  It's pretty simple to setup the DOS command line,
and 
you can include the DB signon stuff(instance, userid, pass), along with
any 
flags you use.  You can designate a pull down menu selection or hotkey
for 
different database instances.

I have a document which I created for our staff outlining the steps to
set 
this up I'd be willing to share.  Contact me directly if you'd like a
copy 
as an attachment.

David Ward




Hi all,
I am getting tired of typing in the database and user id in the sqr 
dialogue box every time I run my sqr to test it. I know I can append
report 
parameters in the icon properties (see below). Is there any way to
modify 
the icon so that it will autopopulate the database and username each
time I 
double click it??
W:\UUSOFT\PSFS840\bin\sqr\DB2\BINW\sqrw.exe -Iw:\UUSOFT\PSFS840\sqr\ 
-Mc:\dragon\code\startup.cfg -fc:\temp -oc:\temp\sqr.log -s
thanks in advance,
clark 'the dragon' willis




David Ward
Technology & Information Resources
UW-Whitewater
800 W. Main St.
Whitewater, WI  53190
262-472-1039
Fax:     262-472-5733


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users