RE: [sqr-users] Re: Problem with data being inserted intoatablefroman array

["the dragon" <ceprn@hotmail.com>]

Richard,

Thanks.  It's been a while since they have let me play with SQR, doing PS 
Admin stuff the past few years.  Relying on my memory, which isn't getting 
any better with age, and some of the sectors are getting overwritten with 
newer stuff.

I was going to go dig out my SQR language ref manual from the box it's in to 
quote the source (in which case I would have caught myself before posting) 
but I have too much other crap going on to do that, plus I'm lazy.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----


Sorry to contradict, Clark, but isblank checks for "empty string, null
string, or composed entirely of whitespace" p 179 SQR Server v4.3.


Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----

Denise,

I think you may be incorrect.  Unless they changed the functionality,
isblank only checks for spaces; isnull checks for nulls.

peace,
clark 'the dragon' willis

----Original Message Follows----

I agree.  I find isblank() to be very useful, since it encompasses both
blanks and null values.

(BTW, I suddenly have started receiving the digest again this week,
after a number of months without receiving it.  Thanks, Nathan, or
whoever did something to reactivate it!)

Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
----------------------------------------------------------------------

Message: 1
Date: Tue, 28 Feb 2006 14:51:41 +0000 (GMT)
From: john.tucker@oracle.com
Subject: [sqr-users] Re: Problem with data being inserted into a table
        from    an array
To: sqr-users@sqrug.org
Message-ID: <4251069.1141138301050.JavaMail.oracle@web241.oracle.com>
Content-Type: text/plain; charset="iso-8859-1"

Akiko -

I like to use isblank for things like that, because it returns a "true"
value whether the variable being passed in is one blank space, eighty
blank spaces, or null.  Your If statement would look like this:

if (not isblank($in_vendor_id) and not isblank($in_std_id_num))

(the outer parentheses being optional, of course)

-John Tucker

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


_______________________________________________
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

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users