Subject | Bug in Firebird 1.5.2 or in FreeUdf.dll |
---|---|
Author | henry FRANQUET |
Post date | 2006-01-27T15:04:58Z |
Hi,
When using Claudio Valderama FreeUdf f_BlobLeft inside a Stored Proc
or with IBOConsole Interactive SQL, the result string is appended with
stuff belonging to a previous call
for example
select first 1 SERIAL, f_BlobLeft(COMMENT, 1020)
from T_NOTE
where PROSP = :lProsp and cast(DTCREA as date) = cast(:lDTCREA
as date)
into :lSerial, :lCommentNote;
if first call comment is 'aaaa ...' 100 caracters length
and second call comment is 'bbbbb' I get something like
'bbbbbaaaaaaaaaa' !
When using Claudio Valderama FreeUdf f_BlobLeft inside a Stored Proc
or with IBOConsole Interactive SQL, the result string is appended with
stuff belonging to a previous call
for example
select first 1 SERIAL, f_BlobLeft(COMMENT, 1020)
from T_NOTE
where PROSP = :lProsp and cast(DTCREA as date) = cast(:lDTCREA
as date)
into :lSerial, :lCommentNote;
if first call comment is 'aaaa ...' 100 caracters length
and second call comment is 'bbbbb' I get something like
'bbbbbaaaaaaaaaa' !