Just in case it helps, here's the source for one of my SPs:
create procedure PREDICT_COST_1 (BARCODE VarChar(25), STOREID INTEGER)
returns (THE_COST Double Precision) as
DECLARE VARIABLE TEMP_COST Double Precision;
BEGIN
select first 1 itemcost from orderitems A inner join orders B on A.orderid
= B.orderid
where A.itembarcode = :BARCODE and A.itemqtyordered > A.itemqtyreceived
and A.itemcost > 0 order by B.orderdate desc into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 A.vpcost from vendorproducts A inner join products B
on A.VPUPC = B.PRODBARCODE and A.VPVENDOR = B.PRODSOURCE
where B.prodbarcode = :BARCODE and A.STOREID = :STOREID and A.vpcost > 0
into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 vpcost from vendorproducts
where vpupc = :BARCODE and STOREID = :STOREID and vpcost > 0 into
:TEMP_COST;
END
END
THE_COST = TEMP_COST;
END
Do you see anything about it that may cause it to not get imported?
-Joe
On Wed, Jan 9, 2013 at 9:03 AM, Joseph Martinez <j...@jmmsoftware.com>wrote:
> Jiri,
>
> I'm not familiar with Trace API. What output log would I look at, and how?
>
> -Joe
>
>
> On Wed, Jan 9, 2013 at 5:13 AM, Jiri Cincura <disk...@cincura.net> wrote:
>
>> Without any further clue, it's hard to guess. Is the database queried
>> for SPs? Do you see the query (TraceAPI, Output log, ...)?
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
>> and much more. Keep your Java skills current with LearnJavaNow -
>> 200+ hours of step-by-step video tutorials by Java experts.
>> SALE $49.99 this month only -- learn more at:
>> http://p.sf.net/sfu/learnmore_122612
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
------------------------------------------------------------------------------
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
