Re: quote-space-quote

[Anne-Marie Matula <amatula@OIT.UMASS.EDU>]

>Gina Bencke wrote:

>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.

I just wanted to say this isn't entirely true (that is if by "string"
variable, you and Joe mean here a variable used for both dates and
non-dates).

Date fields that are not required fields in PeopleSoft can have null values
(required date fields cannot be null). Thus, the string variable used to
update a non-required date field can have a value of null.

My rule, as regards initializing values is:
numeric  = 0
string (non-date) = BLANK (' ')
string (date)  = NULL ('')

Hope that helps

Anne-Marie

P.S. I receive this in digest format so if I am repeating what someone else
said, please do not think I am losing it!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
Whitmore Bldg, University of Massachusetts, Amherst
Phone:  413/577-0685