RE: [sqr-users] Encapsulate with Double-Quotes

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

How are you transmitting the "certain information" to the SQR program?  By
any chance, is the Oracle form appending it to the end of the command line
for sqrw.exe?  If so, the problem is the operating system, not Oracle Forms
or SQR.  A space on a command line is the separator between parameters.  The
software that is creating the command line must put in the quote marks, or
your SQR program has to perform an input statement within a while loop to
pick up each word separately, until $MethodName returns ''.

-----Original Message-----
From: Happersberger. Rich (MSA) [mailto:happersbergerr@SacCounty.NET]
Sent: Monday, April 26, 2004 7:38 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Encapsulate with Double-Quotes



Greetings -

I'm using Brio as my report writer against an Oracle db and an
application using Oracle forms.

When I have my users submit a certain job through the forms, they must
enter certain information. No matter what they type, only the first word
will be captured in the resulting ASCII file.

The forms developer suggested I encapsulate the entries in the forms
with double-quotes. If I make an entry to forms and use double-quotes to
encapsulate the entry, all the narrative is returned to the file.

I've tried to do this in Visual-Sqribe using the following in order to
save some extra demands on the users (remembering to use the quotes) -

move '<34> <34>' to $MethodName
input $MethodName 'Specify Method Name' type=char

This is not working - again only the first word of the narrative is
retruned to file no matter how
loooooooooooooong it might be.

TIA -

Rich Happersberger
Asst. Systems Administrator
SRCSD Laboratory (MSA)



____________________________________________________________________________
_______________________________
This email and any attachments thereto may contain private, confidential,
and privileged material for the
sole use of the intended recipient. Any review, copying, or distribution of
this email (or any attachments
thereto) by other than the County of Sacramento or the intended recipient is
strictly prohibited.

If you are not the intended recipient, please contact the sender immediately
and permanently
delete the original and any copies of this email and any attachments
thereto.
____________________________________________________________________________
_______________________________

_______________________________________________
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