Subject | Re: Adding parameters to an Existing TIBOStoredProc |
---|---|
Author | jack_engleman |
Post date | 2006-11-01T17:09:11Z |
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
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
> >
>