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/
