Thanks everyone for your help.
In fact where I thought I was working with dialect1 the database had
'slipped' into dialect3. I had done a backup-and-restore using ibconsole,
and without doing anything special it had converted my database to
dialect3.!

However I don't know for sure if that was the cause of the stored proc
problem because I set about writing a list of parameter names for the stored
procs, and with this list given (rather than having to get them from the
metadata), I had no further problems from that anyway.
Regards

Dave

, but it did cause me problems because all the other databases in my system,
were still dialect 1.

"Lucas Franzen" <luc@...> wrote in message
news:3BC20565.5C6FB535@......

>
> What does the SQ-property of the StoredProcs conmponent look like?
>
> Does it work when you're executing them inside TIB_DSQL statements; you
> have to enter the SQL manually then, like: "execute procedure sp_test (
> :param1, :param2, ...)"?
>
> Luc.
>
> comesailing@... schrieb:
> >
> > Help with stored procs Please !
> >
> > I have a program which uses stored proces extensively.
> > It has work for a couple of years but I have upgraded from IBobjects
> > 3.6 to 4.?
> > AND I have gone from Delpi4 to D6 AND from interbase 5.5 to firebird.
> > Yes I know one should make one change at a time !!
> >
> > However I now get 'parameter mismatch' when almost every stored
> > program is called.
> > I did use 'now' within IB and thought that was the cause. So took it
> > out. Still the same effect.
> >
> > I use autoparameters for the stored proc which worked fine. But on
> > close examination I see that I have parameters in my stored procs
> > which are not fields of the relation to which it refers.
> >
> > This used not to matter. I assume the autoparams were obtained from
> > the stored proc. But now it looks as though they are obtained from
> > the relation ??
> >
> > Anyway it looks as though I shall have to tell each stored proc its
> > 'ParamNames'. In which case do I have to precede them with '?' or ':'
> > or nothing.
> > e.g. storedproc1.paranames.add('surname,firstname,...');
> > or storedproc1.paranames.add(':surname,:firstname,... ');
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>