Subject Re: Adding parameters to an Existing TIBOStoredProc
Author jack_engleman
I finally figured out the problem and the fix. I have a module that
contains my database connection (TIBODatabase) for my application. In
the module I was having problems, I had this file placed under uses
in the application area of this module. I found a different module
where every thing worked correctly and noticed that the database
module was referenced in the uses area in the interface. I moved the
database module to the interface area of the module where I was having
the problem and this cured the problem. My Delphi design area now
behaves correctly.

Thanks for the help Helen

Jack



--- In IBObjects@yahoogroups.com, "jack_engleman" <jengleman@...> wrote:
>
> Helen
>
> The funny thing is the database works I can run the program from
> delphi in debug mode, as I normally do to test. So the connection
> works in run mode.
> I can open and explore the database from within Delphi.
>
> I believe the adding of parameters was working at one time, but it
> seems to have broken.
> I thought that the connection with database during design time was a
> BDE connection, but the error I am getting is from the IBO interface.
>
> Jack
>
> --- In IBObjects@yahoogroups.com, Helen Borrie <helebor@> wrote:
> >
> > At 05:44 PM 1/11/2006, you wrote:
> > >I have used Delphi for over 6 years and I have made changes to an
> > >existing stored procedure and been able to change the parament list
> > >easily. Using TStoredProc on Delphi 6, you can add a parameter to an
> > >existing stored procedure you delete the existing stored procedure
> > >name and then re-select the stored procedure and the Parameters can
> > >then be added to the parameters list. Every time I try to do using
> > >the IBO equivalent this I get an error: File is not a valid
database.
> >
> > This error means you have a problem at the connection level - your
> > application is trying to connect to a file that is not a database!
> >
> >
> > >What method should I use to update the changes in a stored procedure
> > >using Delphi 6??
> >
> > Should be the same as for TStoredProc, if you want to do it that
> > way. You need to find out what has happened to your database file...
> >
> > Helen
> >
>