hmm...it works without it, myseriously:

execute procedure sel_product_by_product_id(parm1, parm2.....

_____

From: Agibov Dmitry [mailto:agibov@...]
Sent: Thursday, December 09, 2004 1:55 AM
To: Storage Box
Subject: Re: [firebird-support] Simple stored procedure won't work



Hi!

Put 'Suspend' statement at the end of your procedure like this:

create or alter procedure sel_product_by_product_id
(
product_id int
)
returns
(
product_id_ int,
product_name_ varchar(50),
product_num_ varchar(50),
synopsis_ varchar(500),
description_ varchar(1000),
wholesale_price_ decimal(9, 2),
unit_price_ decimal(9, 2),
sale_price_ decimal(9, 2),
weight_ decimal(9, 2),
height_ decimal(9, 2),
width_ decimal(9, 2),
length_sz_ decimal(9, 2),
insured_value_ decimal(9, 2),
is_free_shipping_ char,
shipping_amt_ decimal(9, 2),
is_cross_sell_ char,
thumbnail_ varchar(100),
photo_ varchar(100)
)
AS
begin
select
product_id,
product_name,
product_num,
description,
synopsis,
wholesale_price,
unit_price,
sale_price,
weight,
height,
width,
length_sz,
insured_value,
is_free_shipping,
shipping_amt,
is_cross_sell,
thumbnail,
photo
from
product
where
product_id = :product_id
into
:product_id_,
:product_name_,
:product_num_,
:synopsis_,
:description_,
:wholesale_price_,
:unit_price_,
:sale_price_,
:weight_,
:height_,
:width_,
:length_sz_,
:insured_value_,
:is_free_shipping_,
:shipping_amt_,
:is_cross_sell_,
:thumbnail_,
:photo_;

SUSPEND;
end
^

Its must work ..












Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129m969os/M=324847.5707095.6763799.3001176/D=gr
oups/S=1705115386:HM/EXP=1102683405/A=2343726/R=0/SIG=12idi62ok/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1102597005031429>
<http://us.ard.yahoo.com/SIG=129m969os/M=324847.5707095.6763799.3001176/D=gr
oups/S=1705115386:HM/EXP=1102683405/A=2343726/R=1/SIG=12idi62ok/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1102597005031429>


Get unlimited calls to

U.S./Canada


<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=11025970
05031429>

<http://us.adserver.yahoo.com/l?M=324847.5707095.6763799.3001176/D=groups/S=
:HM/A=2343726/rand=703709865>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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