Unexpected exception object raised: [EAbort]

Hi,

With the query listed below I get the following error message returned
if I excute it in either my application and or if I run the query from
the DB Workbench function editor.

***** However ******* If I run the query from the SQL script editor in
DB Workbench it returns the proper result set without any exception
error.


NexusDB: Query execution failed:
Unexpected exception object raised: [EAbort] Operation aborted
[$3CA1/15521]


I do not understand how it can excute in one section of DB Workbench
with proper results returned, and then create a exception in my
application code and or in a different section of DB Workbench.

In my application the function is excuted by , Get_Report_BOM(et_ID);

As per normal the exception message is next to usless, so can anyone
shed some light on what the problem is ?

Kind Regards
Grant Brown


------------- the query -------------------


CREATE FUNCTION Get_Report_BOM(Det_ID Integer)
RETURNS Table
READS SQL DATA
begin
Return
SELECT
MF.Display_Name,
MS.Item_Name,
MS.Man_Ref,
SH.Dispaly_Name,
MS.Sup_Ref,
MS.Unit_Type_ID,
Count(JC.Auto_ID) as Qty
FROM
Job_Components JC
INNER JOIN Man_Stock MS ON Job_JC.Component_ID = MS.Auto_ID
INNER JOIN Manufactures MF ON MS.Master_ID = MF.Auto_ID
INNER JOIN Suppliers_Head SH ON MS.Supplyer = SH.Auto_ID
WHERE
JC.Master_ID = Det_ID
GROUP BY
MF.Display_Name,
MS.Item_Name,
MS.Man_Ref,
SH.Dispaly_Name,
MS.Sup_Ref,
MS.Unit_Type_ID
ORDER BY MF.Display_Name, MS.Item_Name;
end;


--

A bit more feed back,

It seems that if I run the query directly from a TQuery component in my
application instead of as a stored function in the DB it excutes
without any problem and returns a proper result set.

So go figure ?????

Kind Regards
Grant Brown



Grant Brown wrote:

>
> Hi,
>
> With the query listed below I get the following error message returned
> if I excute it in either my application and or if I run the query from
> the DB Workbench function editor.
>
> ***** However ******* If I run the query from the SQL script editor
> in DB Workbench it returns the proper result set without any exception
> error.
>
>
> NexusDB: Query execution failed:
> Unexpected exception object raised: [EAbort] Operation aborted
> [$3CA1/15521]
>
>
> I do not understand how it can excute in one section of DB Workbench
> with proper results returned, and then create a exception in my
> application code and or in a different section of DB Workbench.
>
> In my application the function is excuted by ,
> Get_Report_BOM(et_ID);
>
> As per normal the exception message is next to usless, so can anyone
> shed some light on what the problem is ?
>
> Kind Regards
> Grant Brown
>
>
> ------------- the query -------------------
>
>
> CREATE FUNCTION Get_Report_BOM(Det_ID Integer)
> RETURNS Table
> READS SQL DATA
> begin
> Return
> SELECT
> MF.Display_Name,
> MS.Item_Name,
> MS.Man_Ref,
> SH.Dispaly_Name,
> MS.Sup_Ref,
> MS.Unit_Type_ID,
> Count(JC.Auto_ID) as Qty
> FROM
> Job_Components JC
> INNER JOIN Man_Stock MS ON Job_JC.Component_ID = MS.Auto_ID
> INNER JOIN Manufactures MF ON MS.Master_ID = MF.Auto_ID
> INNER JOIN Suppliers_Head SH ON MS.Supplyer = SH.Auto_ID
> WHERE
> JC.Master_ID = Det_ID
> GROUP BY
> MF.Display_Name,
> MS.Item_Name,
> MS.Man_Ref,
> SH.Dispaly_Name,
> MS.Sup_Ref,
> MS.Unit_Type_ID
> ORDER BY MF.Display_Name, MS.Item_Name;
> end;



--

> With the query listed below I get the following error message returned
> if I excute it in either my application and or if I run the query from
> the DB Workbench function editor.

Any chance of borrowing the tables to reproduce?


--

Eivind Bakkestuen
Nexus Database Systems Pty Ltd