[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: SQR-USERS Digest - 14 Nov 1999 to 15 Nov 1999
- Subject: Re: SQR-USERS Digest - 14 Nov 1999 to 15 Nov 1999
- From: "Jackson, Carrie" <carriejackson@NFISG.COM>
- Date: Wed, 17 Nov 1999 08:26:50 -0600
Can you please tell me how I "un-subscribe" to this service? Thanks!
....Some days you're the dog....some days you're the hydrant..........!!!
Carrie Jackson
1st floor-Walnut
557-7978
CarrieJackson@NFISG.com <mailto:CarrieJackson@NFISG.com>
-----Original Message-----
From: Automatic digest processor
[mailto:LISTSERV@list.iex.net]
Sent: Monday, November 15, 1999 1:03 AM
To: Recipients of SQR-USERS digests
Subject: SQR-USERS Digest - 14 Nov 1999 to 15 Nov
1999
There are 5 messages totalling 226 lines in this issue.
Topics of the day:
1. sqr 5 warnings
2. Emailing in Scribe (2)
3. Version 5 of SQR
4. SQL return limits
----------------------------------------------------------------------
Date: Mon, 15 Nov 1999 09:19:33 -0500
From: Schiff Fred <FSCHIFF@NLFS.COM>
Subject: Re: sqr 5 warnings
The warning came up 4 times on my sample because I
printed dates in this manner 4 times. A warning
which comes up 10,000+ times in a normal run, is not
a warning that should be ignored.
-----Original Message-----
From: Clara Carter [mailto:clarac@RAINMAKERSYSTEMS.COM]
Sent: Friday, November 12, 1999 5:35 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: sqr 5 warnings
It's just a warning and your program will run.
cc
At 05:20 PM 11/12/99 -0500, you wrote:
>Seems like a silly warning.
>
>We are *printing* 2 digit years cause thats all that fits.
>I can look at an activity date and know which century it is
in.
>
>For inputting dates, I've been using 4 digit years for a
few years.
>(sqr 2.5)
>
>-----Original Message-----
>From: Fay, Brannon [mailto:brannon.fay@PAETEC.COM]
>Sent: Friday, November 12, 1999 4:38 PM
>To: Multiple recipients of list SQR-USERS
>Subject: Re: sqr 5 warnings
>
>
>You can do 1 of 2 things:
>
>1) Change your date to be Y2K compliant and use 4 digits
for the year, i.e.
>MM/DD/YYYY
------------------------------
Date: Fri, 12 Nov 1999 15:30:45 +0200
From: Jason Wainwright <JasonW@LIMON.CO.ZA>
Subject: Emailing in Scribe
Hi all
We have an NT system going with SQR 4, we use a delphi 2
front to be our
print manager. We would like to be able to send email and
the documentation
we have is sketchy. Currently Delphi call SQRWT with
commandline parms. So
does anyone know how SQRWT handles email? Details,
anecdotes, sites etc
anything.
TIA
------------------------------
Date: Mon, 15 Nov 1999 09:05:51 -0600
From: Arturo Vega <arturo_vega-consultant@PEOPLESOFT.COM>
Subject: Re: Version 5 of SQR
You can order SQR Manuals directly from Brio Technology web
site
http://www.brio.com
Greetings from Mexico!!
Arturo Vega
Mexican Payroll Development Team
PeopleSoft Mexico
We called up SQR/MITI/Brio, whoever they are this week, to
get the new
version of SQR.
We are using SQR4.2.3 on an HP Unix machine.
We are not using any kind of graphical tools, but just
writing straight
programs
with the mighty editor vi.
I wanted SQR4.3+, because I had heard that it was capable of
producing
pdf files directly, without having to go throught the step
of making
postscript
files first.
We got 2 CD's for Brio SQR ver 5.1 (ie. a major version,
rather than a
minor
version upgrade!!!) and a thin manual. The upgrade manual
mentions
that there are 2 reference manuals, but we did not get them.
We haven't
installed it as of yet, but it is happening as we speak.
Are the manuals on the CD, or do we have to order them
separate?
and
Can anybody tell the changes that have taken place and/or
any problems
we will encounter running older programs?
I notice that lists have been added. Variables prefixed
with %
How are they used?
Thanks
Fred Schiff (fschiff@nlfs.com)
212/413-4807
Nathan & Lewis Securities, Inc.
------------------------------
Date: Mon, 15 Nov 1999 10:14:12 EST
From: Manoj Gurjar <mgurjar@HOTMAIL.COM>
Subject: Re: SQL return limits
For SQR :
A) Use LOOPS with Begin-select to specify no of rows.
Begin-select LOOPS=100
B) Some counter
let #i = 1
Begin-Select
Fields
let #i=#i+1
do all-processing
if #i = 100 ! before FROM
break
end-if
FROM table
where....
3) On Oracle Backend Select use ROWNUM <= 100 in where.
HTH
Manoj
>From: "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS
<SQR-USERS@list.iex.net>
>Subject: SQL return limits
>Date: Fri, 12 Nov 1999 16:23:14 -0500
>
>Hi All.
>
>Is there a way to limit the number of returned records in
an SQL statement?
>examples, the table contain 100,000 records. I just want
the first 100
>records.
>
>Thank You
>Binh
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
------------------------------
Date: Mon, 15 Nov 1999 09:54:14 -0600
From: Krishnan Sarangarajan <ksaranga@RUAN.COM>
Subject: Re: Emailing in Scribe
Jason - Though this message is not related to SQRWT, I hope
that it sheds
some light on what you are trying to achieve.
Here at Ruan, we have always had the need to mail reports
from within an
SQR.
Exchange & Outlook 97 [our mail applications] do not seem to
have the
ability to be invoked from a command line such that a
message can be sent
without any user intervention. Or, if there was a way, we
couldn't figure it
out.
A colleague of mine, who works with VB, had some code that
achieved what we
wanted. However, we didn't want to use VB as the
intermediary. This is what
we agreed on :
1. SQR runs and creates a report [LIS file] for each of the
terminals in
question,
2. The SQR also creates a file with the names of the
terminals and their
e-mail addresses,
3. Towards the tail end of the report, a batch file is
created and Word is
called,
4. There is an AUTORUN macro within WORD that will be
executed,
5. This macro will run to completion only if file from (2)
exists,
6. Using the file names and the e-mail addresses, the VB
function is called
repeatedly, and
7. When the macro has completed, it has the ability to close
down Word and
return control to the SQR.
Like I said, I am not sure if this is of any help to you but
if you are
completely stuck, give me a call and I will be happy to
discus the above
with you...
Sincerely,
Krishnan
Ruan Transportation Management Systems
(515) 245-5655 [P]
(515) 247-2065 [F]
ksaranga@ruan.com
-----Original Message-----
From: Jason Wainwright [mailto:JasonW@LIMON.CO.ZA]
Sent: Friday, November 12, 1999 7:31 AM
To: Multiple recipients of list SQR-USERS
Subject: Emailing in Scribe
Hi all
We have an NT system going with SQR 4, we use a delphi 2
front to be our
print manager. We would like to be able to send email and
the documentation
we have is sketchy. Currently Delphi call SQRWT with
commandline parms. So
does anyone know how SQRWT handles email? Details,
anecdotes, sites etc
anything.
TIA
------------------------------
End of SQR-USERS Digest - 14 Nov 1999 to 15 Nov 1999
****************************************************