did you commit after you created the table?
-----Original Message-----
From: Regina Phandu [mailto:regina@...]
Sent: Saturday, 28 September 2002 11:27
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] stored procedure


ok, i realize i did some mistakes, but right now it said that table
tm_pos_product is unknown.
I did create that table in my database. don't know why the error said that
the table is unknown!

set term !!;
create procedure sp_tot_prod_qty (prod_code integer)
returns (tot_prod_qty float)
as
declare variable qty_display float;
declare variable qty_warehouse float;
begin
select qty
from tm_pos_product
where prod_code = :prod_code
into :qty_display;

select qty
from tm_warehouse
where prod_code = :prod_code
into :qty_warehouse;

tot_prod_qty=(qty_display + qty_warehouse);

end !!


Regina


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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