Thanks Alan, I'm sure that your are correct. I guess that is what happens when you don't take a break as you start making silly mistakes.
Much appreciated. On Fri, Apr 6, 2012 at 1:28 PM, Alan J Davies < alan.dav...@aldis-systems.co.uk> wrote: > I don't know what your fields are but it looks like you're trying to > store the MBRID - presumably identifier - into a date field for output. > When you just issue a select that will work, but when you use an SP it > fails. Check your code, or cast(MBRID) as date > > Alan J Davies > Aldis > > > On 06/04/2012 11:42, Mags Phangisa wrote: > > Hi everyone, > > > > The following query works fine when called from the application: > > "SELECT MBRID,POLNO,PTYPE,BNKDT,AMUNT, > > ERROR,RECPT > > from PYMT where BNKDT>='$sttdt' and BNKDT<='$enddt'" > > > > However, the following stored procedure (using the same above query) > throws > > an error: > > > > SET TERM ^ ; > > CREATE PROCEDURE SPS_PYMT (SDT Date, EDT Date ) > > RETURNS (MBR Date, POL Varchar(20), PTY Char(4), BNK Date, AMU > > Decimal(10,2), ERR Char(4), REC Varchar(10) ) > > AS > > BEGIN > > FOR > > SELECT MBRID,POLNO,PTYPE,BNKDT,AMUNT,ERROR,RECPT > > from PYMT where BNKDT>=:SDT and BNKDT<=:EDT > > INTO :MBR,:POL,:PTY,:BNK,:AMU,:ERR,:REC > > DO > > SUSPEND; > > END^ > > > > It throws the following error: > > Conversion error from string "2241" At procedure 'SPS_PYMT' line: 15, > col: 2 > > > > This error comes up even when I execute the procedure directly from > > Flamerobin. > > > > This is how I call it in the application, in case it is relevant: > > > > $qry = ibase_prepare($tt,"select * from SPS_PYMT('$sttdt','$enddt')"); > > $rslt = ibase_execute($qry); > > while($rec = ibase_fetch_object($rslt)) > > { > > ... > > } > > > > Thanx, > > Mags > > > > [Non-text portions of this message have been removed] > > > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed]