🚀 go-pugleaf

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))
RETURNS (
    BDDCODE INTEGER,
    FNAME CHAR(250),
    FSIZE INTEGER,
    FMODIF DATE)
AS
begin
  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,


--

Olivier Dahan
______________________________________________________
ICQ#: 165591752
More ways to contact me: http://wwp.icq.com/165591752
______________________________________________________