Hi all,

I am running Firebird 1.02 on W2K box.

The following query:

"select
party.party_id, profile.*
from
tbl_party party, read_profile(party.party_id) profile"

where "read_profile" is a stored procedure prepares OK but on execution I receive:
"The cursor identified in the update or delete statement is not positioned on a row.
No current record for fetch operation"

BUT,

The folowing query executes OK:

"select
party.party_id, profile.*
from
tbl_party party LEFT JOIN tbl_party party2 on (party.party_id = party2.party_id),
read_profile(party.party_id) profile"

The magic is in the LEFT JOIN. A simple join doesn't work, I get the
same error.

Any ideas?

--
Best regards,
Alexander mailto:saho@...