Has anyone used Navicat 8 to write a stored procedure for Crystal Reports?
I am trying to include a parameter in this simple example to pass to a Crystal Report. The following works in the applications stored procedure designer:
BEGIN
SELECT * FROM TempSales WHERE SaleID > SaleIDParam;
END
However, if I want to reference a parameter on a crystal report i have to have the @ or ? symbol before the SaleIDParam. When I do this the procedure does not run.
Note with the designer you don't have to have the DELIMITER or the PROCEDURE statements.