Topic: Delphi connects to Oracle at design-time when opening form
|
|
Mur
User
Platinum Boarder
| Posts: 116 |   |
Karma: 0
|
|
Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/07 09:49 |
|
|
|
|
Everything is about designtime.
I have TOCIDataBase and TNCSQLMonitorClient placed on datamodule of my porject.
Database.Connected=False and SQLMonitor.Active=true;
When I create new form and place TOCIQuery on it, everything goes fine.
I can close and open this form fast and easy. Once I make it active to get fieldlist and then set Active back to False and saved and closed project. After that, every time I open this form, something sets Connected property of Database to True, and Database connects to Oracle, also datamodule is not even open!
This is very inconvenient. Am I doing something wrong, or this is a bug?
Or maybe feature? 
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/09 18:17 |
|
|
|
|
Hi !
When you activate TOCIQuery, for example, to add fields to dataset, it activates TOCIDatabase. After that TOCIDatabase remains opened, ie TOCIDatabase.Connected = True. So, that is not a bug, and not a feature, but normal functionality.
|
|
Mur
User
Platinum Boarder
| Posts: 116 | |
Karma: 0
|
|
RE: Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/10 08:19 |
|
|
|
|
По-английски наверное не смогу объянить понятно 
Да, когда я впервые сделал Query.Active = True, DataBase.Connected тоже стал True. Это понятно.
Но после этого я делаю Query.Connected := False. Datamodule у меня не окрыт, и поэтому Database.Connected я не трогаю. Закрываю проект, при этом НЕ сохраняю Datamodule, в котором лежит Database.
Когда я в следующий раз открываю проект, все нормально, но стоит мне открыть форму, на которой лежит этот Query (у которого в данный момент Active=False!!!) и DataBase сам начинает коннектиться к Oracle! Повторяю, в момент открытия формы DataBase.Connected := False и Query.Active := False.
Такое странное поведение начинается, когда Query хоть раз побывал Active в design-time. Такое у меня происходит не с одной формой, а со всеми формами, которые я создаю в проекте. То есть это не случайность, я могу легко воспроизвести ситуацию.
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/10 08:45 |
|
|
|
|
Hi Vladimir !
Okey, i have understood issue. Investigating it ...
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/11 17:10 |
|
|
|
|
Hi Leonid !
) I simply forget, what i wrote ...
It is very easy - TOCIQuery has property Prepared. When you open TOCIQuery, it has Prepared = True also. But when you close it, Prepared remains True. When TOCIQuery is prepared, TOCIDatabase must be connected.
|
|
Mur
User
Platinum Boarder
| Posts: 116 | |
Karma: 0
|
|
RE: Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/11 18:07 |
|
|
|
|
Great thanx,
I guess this should be in FAQ.
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Delphi connects to Oracle at design-time when opening form
|
|
Posted: 2000/08/11 22:21 |
|
|
|
|
|
Completely agree ! See FAQ 5.4.
|
|
|
