🚀 go-pugleaf

On Tue, 10 Dec 2002 03:16:03 +0100, "odahan" <odahan@e-naxos.com>
wrote:

>Hi all,
>
>problem is simple : it seems that using a parameter in a select after CONTAINING
>doesn't work.
>I explain more deeply :
>Given the following stored proc :
>
>CREATE PROCEDURE SAMEFILE (
>    IFILENAME CHAR(250))

Try VARCHAR(250) here ...

>RETURNS (
>    BDDCODE INTEGER,
>    FNAME CHAR(250),
>    FSIZE INTEGER,
>    FMODIF DATE)
>AS
>begin

... or trim IFILENAME here ... or both

>  for Select distinct b.code, b.filename, b.FileSize, b.Modified
>      from bddbag b
>      where b.FILENAME containing :IFILENAME /** pb here! **/
>      into :BDDCODE, :FNAME, :FSIZE, :FMODIF
>      do
>        suspend;
>end
>
>The problem is : if I use the parameter IFILENAME stored proc returns an empty
>dataset. If I use a hardcoded string like 'foo' instead of the parameter ,
>that's working...
>
>The worse : using the parameter, all seems to be ok when tracing the procedure
>execution under debugger (like the one in QuickDesk). But used in interactive
>mode (ibconsole for example), the result set is empty.
>
>I'll be glad to know if this is a known problem and if there is a way to turn
>around.
>
>Thanks in advance,