Well, the subject line did say, "Interesting Behavioral Quirk", although
it's probably < interesting, as it were.
Thought you'd chime in on this one, but I didn't know how to many
"attachment points" you'd "chelate".
Later,
Steve
----- Original Message -----
From: "Bill Downall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 12:41 PM
Subject: Re: Interesting Behavioral Quirk
> Steve,
>
> Try another pair of parentheses to surround your whole expression:
>
> UPDATE ACTIVITIES SET
> SourceSystemID = (IFGT((SLEN(SECActivityCD)) ,2, "ACCENT",
> "JTPA"))
>
> How come an old SQL wonk like you is still using double quotes?!
>
> Bill
>
>
> On Tue, 10 Dec 2002 11:57:12 -0600, J. Stephen Wills wrote:
>
> >Now, I'm not talking about my degree of socialization or my
> personality -
> >although I do go to the university bookstore here each fall to see if
> my pic
> >is on the abnormal psych text - but rather an odd little think I found
> this
> >AM using a (conversion) function embedded in a Boolean function :
> >
> >(R.1>) UPDATE ACTIVITIES SET
> >SourceSystemID=IFGT((SLEN
> (SECActivityCD)),2,"ACCENT","JTPA")
> >(R.2>) UPDATE ACTIVITIES SET
> >SourceSystemID=IFGT((SLEN(SECActivityCD)),
> (2),"ACCENT","JTPA")
> >
> > These two each echoed in the dialog "- ERROR - The column or
> variable 2
> >not found. (2515)"
> >
> >
> >(R.3>) UPDATE ACTIVITIES SET
> >SourceSystemID=IFGT((SLEN
> (SECActivityCD)),"2","ACCENT","JTPA")
> >
> > This one echoed the expected type-mismatch error, "- ERROR -
> The first
> >and last two arguments for IFEQ must be the same type. (2155)"
> >
> >
> >(R.4>) UPDATE ACTIVITIES SET
> >SourceSystemID=IFGT((SLEN(SECActivityCD)),INT
> ("2"),"ACCENT","JTPA")
> >
> >
> >The Tom Grimshaw incident notwithstanding, I'm not trying to nitpick
> w/RBTI,
> >but I am curious as to why the initial 2 forms of the statement failed
> to
> >execute. The third I understand. The fourth, as I indicated, worked
> as I'd
> >expected the first 2 to work.
> >
> >Could it be that there is a "func" data-type, implicit by its nature, but
> >required such that only form 4 executable? This would be consistent
> w/the
> >syntax rule violation of form 3 ...
> >
> >Any thoughts?
> >
> >
> >Later,
> >Steve in Memphis
> >
> >================================================
> >TO SEE MESSAGE POSTING GUIDELINES:
> >Send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: INTRO rbase-l
> >================================================
> >TO UNSUBSCRIBE: send a plain text email to
> [EMAIL PROTECTED]
> >In the message body, put just two words: UNSUBSCRIBE rbase-l
> >================================================
> >TO SEARCH ARCHIVES:
> >http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
>
>
>
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
