stored procedure

[mirage10]

pervasive sql 8
crystal v 8.

Hi,
I have never accessed a stored procedure from crystal.. so pl. advise.
I have stored procedure like below which returns data on the db.. but when I tried to "add" the stored procedure to the report, it gave me the err msg: no data returned.

Pl. advise on what might be wrong.

thanks


CREATE PROCEDURE ordernoMO() AS

begin
//declare moitem = MIMOH."ITEM" & "0000"
SELECT
OEORDH."ORDNUMBER",
OEORDD."QTYORDERED", OEORDD."ITEM",
MIMOH."WOHID", MIMOH."ITEM"
FROM
"OEORDH" OEORDH INNER JOIN "OEORDD" OEORDD ON
OEORDH."ORDUNIQ" = OEORDD."ORDUNIQ" INNER JOIN "ICITEM" ICITEM ON
OEORDD."ITEM" = ICITEM."FMTITEMNO" INNER JOIN "MIMOH" MIMOH ON
ICITEM."ITEMNO" = MIMOH."ITEM"+ '0000'
WHERE
OEORDD."QTYORDERED" <> 0
ORDER BY
OEORDH."ORDNUMBER" ASC,
OEORDD."ITEM" ASC;

end;



------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[mirage10]

sorry the exact err message i am getting is

error opening file:
"there are no fields in the file "ADH.Proc(bulk)"

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[Madawc]

I used to use stored procedures with Crystal 8.5. This needed Crystal SQL Designer to create something that Crystal 8.5 could 'see' via the 'Add Database'. (It's all much simpler in Crystal 10.)

Madawc Williams (East Anglia, UK)