I found that there was a problem : another developer had worked on
the Delphi code, and the parameter types given did not match the
actual parameter types expected.

For example :

ParamByName('pPumpNum').AsFloat := lPumpNum;
ParamByName('pNozNum').AsFloat := lNozNum;

where both pPumpNum and pNozNum are parameter type integer.

I changed the "AsFloat" to "AsInteger".

It is in testing at the moment. :holdthumbs: :)

Thanks for your help.

As far as IBX goes - yes, one of the TeamB guys suggested exactly the
same thing. However, our data structures are simple, as are our
stored procedures. Furthermore, we keep all transactions atomic - as
atomic as we can get them. So far, we have not had any problems;
although I have suggested to the Div manager that we need to look at
changing to IBO

Thanks again

Tim

At 14:20 01/12/2005, you wrote:

>--- In firebird-support@yahoogroups.com, Tim <tim@s...> wrote:
> >
> > Hi,
> >
> > I am using IBX 5.04 (Delphi 5 SP 1) on a Firebird database.
> >
> > We are getting an error "XSQLDA index out of range" on an
> > IBStoredProcedure.
> >
> > The stored procedure does an update of a table : there is no associated
> > IBQuery. We use the IBStoredprocedure component directly.
> >
> > What is causing this problem, and how can we fix it?
> >
> > Thanks
> >
> > Tim
> >
>Not sure that IBX is compliant with Firebird anymore, they've diverged
>too much.
>Whenever I have problems like that I
>1) Check db to see if it has any problems - gfix with switches -
>after I moved the db off the development machine those types of
>problems disapeared.
>2) Make sure everyone is off and delete the firebird lck file
>
>mick
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit
><http://firebird.sourceforge.net>http://firebird.sourceforge.net and
>click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at
><http://www.ibphoenix.com>http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
>SPONSORED LINKS
><http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw>Technical
>support
><http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>Computer
>technical support
><http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g>Compaq
>computer technical support
><http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>Compaq
>technical support
><http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA>Hewlett
>packard technical support
><http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>Microsoft
>technical support
>
>
>----------
>YAHOO! GROUPS LINKS
>
> * Visit your group
> "<http://groups.yahoo.com/group/firebird-support>firebird-support" on the web.
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
>
>
>----------

[Non-text portions of this message have been removed]