Here is a SP...
ALTER PROCEDURE SP_LOAD (
GAMEKEY BIGINT,
PLAYERKEY BIGINT)
RETURNS (
PKEY INTEGER,
DIEKEY INTEGER,
STRIP VARCHAR(24))
AS
begin
select PKEY,DIEKEY,STRIP from DICE
where (GAMEKEY=:gamekey and PLAYERKEY=:playerkey)
into pkey,diekey,strip;
suspend;
end
I can enter: select PKEY,DIEKEY,STRIP from DICE where GAMEKEY=22 and
PLAYERKEY=6
... and I get back several results row.
If I enter: select PKEY,DIEKEY,STRIP from SP_LOAD(22,6)
... I get zero rows.
This make no sense to me. Does it make any to you?
Thanks for any help :-)


[Non-text portions of this message have been removed]