🚀 go-pugleaf

"Adalberto Baldini" <finman@swissonline.ch> wrote in message 
news:480e09f4$1@newsgroups.borland.com...
> If I  try :
> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, 'ABIT', 'DETO') 
> b
> on (b.abinp = 'ABIT' and b.fil = 'DETO' )
> where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
> 'DETO'
>
> OR
>
> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc,  'ABIT', 
> 'DETO')
> b
> on (b.abinp = a.abinp and b.fil = a.fil )
> where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
> 'DETO'
>
> I get  right data:
>
> select [..]
> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, a.abinp, a.fil) 
> b
> on (b.abinp = a.abinp and b.fil = a.fil )
> where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
> 'DETO'
>
> I get
> ABIT   DETO    null null null null

That definitely is a puzzle, it looks like the data must be right, so 
possibly there's a bug somewhere.

What happens if you, using IBConsole or ISQL, simply select directly from 
the stored procedure passing various parameters? Do you always get correct 
returns? Is the stored proc properly calling SUSPEND to return a result set 
rather than a single set of return values? (Even if it is designed to always 
return just one record, if you are going to use it as part of a select 
statement it must call SUSPEND as far as I know).

-- 
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca)