At 02:02 PM 30/10/2003 +0100, you wrote:

>CREATE PROCEDURE details (arg1 INTEGER, arg2 INTEGER, arg3 CHAR(1))
> RETURNS (code INTEGER, description VARCHAR(30)) AS
>BEGIN
> FOR SELECT t.code, d.description
> FROM table t
> JOIN descs d
> WHERE t.key1 = :arg1 AND t.key2 = :arg2 AND t.key3 = :arg3
> INTO :code, :description DO
> SUSPEND;
>END
>
>SELECT sp.code, sp.description
>FROM Table t
>LEFT JOIN details(t.Field1, t.Field2, 'A') sp ON 1=1
>
>*has* and *is* working ok (and **fast**) on all released IB/FB
>servers.
>
>Iff what you meant is that this is not recommended, well, I'm in big
>trouble!-(

No. But it wasn't clear from your initial description whether you were
trying to join the table to a selectable or an executable stored procedure,
since you had no column identifiers and no column-related join conditions.

So I can't imagine what's causing your application to crash.

h