Re: quote-space-quote

["Bencke, Gina" <GBencke@KICHLER.COM>]

Joe,

A string variable can be initialized to quote-quote.  However if this
string variable is used to insert a value into a table and does not
receive a value elsewhere in your program, the insert statement will
fail because PeopleSoft defines character fields as NOT NULL.

Please note that quote-quote defines a null string, while
quote-space-quote defines a string containing a space.

Gina Bencke
Bencke Consulting Corporation
gina@bencke.com

-----Original Message-----
From: Joe Johnson [mailto:jejohn1216@SURFREE.COM]
Sent: Wednesday, October 20, 1999 5:25 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: quote-space-quote


Thanks, Vijay and Gina!

Follow-up question --

Can a string variable be initialized to quote-quote or does it need to
be quote-space-quote?  It would make my life easier if I changed all the
$dates to initialize to '' and not ' '.

Thanks again - in advance

- Joe

On Wed, 20 October 1999, "Bencke, Gina" wrote:

>
> Joe,
>
> SQR 3.x stored dates in sting variables.  SQR 4.3.4 has a date
variable
> type.  The date variable type will accept a null date (quote-quote),
but
> not a string with a space (quote-space-quote). Unfortunately both
string
> variables and date variables begin with a $, so its difficult to know
> what type of variable you are dealing with.
>
> Gina Bencke
> Bencke Consulting Corporation
> gina@bencke.com
>
> -----Original Message-----
> From: Joe Johnson [mailto:jejohn1216@SURFREE.COM]
> Sent: Wednesday, October 20, 1999 3:28 PM
> To: Multiple recipients of list SQR-USERS
> Subject: quote-space-quote
>
>
> Hi, group.
>
> Oracle 8 (upgrade from Oracle 7)
> PS Apps 7.02 (upgrade from 7.01)
> PS Tools 7.05 (upgrade from 7.01)
> SQRW 4.3.4 (upgrade from 3)
>
>
> We are finding that SQR 4.3.4 bombs on SQRs that initialize
> $date_variables to ' ' {that is, quote-space-quote}.
>
> We changed this to '' {quote-quote} and they work.
>
> The quote-space-quote worked fine in SQRW 3.
>
> Anybody else run into this?  Want to explain why?
>
> TIA
>
> Joe Johnson ;{)
> __________________________________________
> $14.95 a month Unlimited Internet Access.
> Get your first month for $1.00.
> http://www.surfree.com/promo

Joe Johnson ;{)
__________________________________________
$14.95 a month Unlimited Internet Access.
Get your first month for $1.00.
http://www.surfree.com/promo