Subject Re: [IBO] Overflow occured during data type conversion
Author ra8009
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 01:57 AM 18/10/2003 +0000, you wrote:
> >I have some SQL like this:
> >
> >SELECT * FROM
> >MY_STORED_PROC(:INT_PARAM1, :STRING_PARAM, :INT_PARAM2)
> >
> >It executes correctly and returns the data I want, however, when I
> >move to the last record (or Delphi moves there in an attempt to
> >populate a grid) I get this error:
> >
> >Overflow occured during data type conversion
> >Conversion error from string "".
> >
> >What's would cause this? How can I prevent it?
>
> Are you using Firebird 1.5? If so, do you have OldParameterOrdering
set to
> True in firebird.conf?
>
> Also, could you show us the declaration of the output parameters in
the SP?
>
> Helen

Yes, I am using Firebird 1.5. In fact I just started using it for this
app. I see the firebird.conf file but currently it appears to be all
comments? How do I set the value?