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/
