Stephen,
Try:
UPDATE ACTIVITIES +
SET SourceSystemID = +
(IFGT(SLEN(SECActivityCD),2,"ACCENT","JTPA"))
Ben Petersen
On 10 Dec 2002, at 11:57, 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/
