🚀 go-pugleaf

Ok... I found what was wrong...
The problem is in the use of CHAR instead of VARCHAR... As it's 4:35 AM here
perhaps muss I go sleeping instead of coding :-)

--

Olivier Dahan
______________________________________________________
ICQ#: 165591752
More ways to contact me: http://wwp.icq.com/165591752
______________________________________________________
"odahan" <odahan@e-naxos.com> a �crit dans le message de news:
3df54e54@newsgroups.borland.com...
: 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
: ______________________________________________________
:
: