Re: quote-space-quote

[the dragon <ceprn@HOTMAIL.COM>]

All,

Keep in mind this **silliness** of every column being not null seems to be
PeopleSoft specific.  Other applications allow you to use null as a valid
value on insert/update as long as the column is not defined as not null.

clark
dragon enterprises, consulting services.


----Original Message Follows----

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

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com