|Subject||RE: [firebird-support] fail when checking VarChar variable <> ''|
> FB 22.214.171.12470OK then are you using the colon : to identify the param?
> XP Pro SP2
> I have a mysterious failure in an SP when I check if a variable is
> I get a "arithmetic exception, numeric overflow, or string truncation"
> when I test for InternalMemo <> ''.
> InternalMemo is VarChar(2000) and is filled from a memo field like this:
> Select...<field list>
> Coalesce(SubString(O.MEMO_INTERNAL From 1 For 1990),'')
> into ... InternalMemo
> Then later in the procedure I check to see if it contains something by:
> if (InternalMemo <> '') then
> ...do something
> But I get the error at the "If" test
> Does this ring any bells with someone? I don't see what I am doing