|Subject||Re: [firebird-support] fail when checking VarChar variable <> ''|
> I have a mysterious failure in an SP when I check if a variable isIsn't problem somewhere in the "...do something" part ?
> 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