BorlandTalk.com

Tumurbaatar S. · Guest

There's TADOConnection component on my app's main form.
Other forms of my app have TADOQuery comp-s and theirs Connection
properties point to the main form's TADOConnection. And every
time the project is loaded in BCB6 IDE, all above Connection properties
are cleared. Bug?

Daniel Stevenson · Guest

I had this problem in my distant past, I'm not sure if it is a bug, I think
it had to do with the order that the forms are loaded and having the
TADOConnection on on a seperate form to your TADOQueries and TADOTables.

I'm also assumming that you are using BCB5 as this is the version I was
seeing it in.

You should probably use DataModules and have the TADOConnection and all
TADOQueries sitting in there, I've not seen the problem since I started
using Data Modules. I also don't have all my TADOQueries connected when the
application starts as this took time to execute the SQL statements and
populate the Queries from the database (especially since I wasn't going to
be using all the Queries at start up)....but my application has over around
70+ tables/queries with some tables with a few thousand records...so load
time of the application was important.

If you didn't want to use a Data Module, you could play around with the
order that the forms are loaded as this had some affect (if my memory is
correct).

"Tumurbaatar S." <nospam_tumur (AT) magicnet (DOT) mn> wrote