I have the following stored procedure which appears to give sensible answers.
SET TERM !! ;
CREATE PROCEDURE gettransdets (jobid integer)
dpexps decimal (12,2) ,
execexps decimal (12,2) ,
fieldexps decimal (12,2) ,
otherexps decimal (12,2) ,
sales decimal (12,2) ,
where jobid = :jobid
SET TERM ; !!
If I run
select * from gettransdets(9000) in the WISQL window I get sensible answers
I am now trying to get delphi to control the query with a Tquery which says
Select * from Gettransdets where jobid =:numb
query1.parambyname('numb').asinteger := 9000;
This fails every time with a message about parameter mismatch.
Can any kind sould tell me what it is I'm doing wrong and perhaps more to the point how to correct it