Master/Detail entry dissapears after reopening project

[mierlp]

Hi

 

I use DevArt components for mySQL connection.

On the servermodule i put the MyConnection component which contains the ip, username/password

On a datamodule i put the Query components.

 

There are 2 Query Components :

- Accounts

- Guests

 

Guest has a Master/Detail to Accounts...but every time i open the project

the Master/Detail is empty and only the MasterFields property contains

the fields.

 

Is this a bug in 0.94.1024 or is there something else wrong and how to solve it?

 

Regards Peter

[rencarnacion]

I guess your Wrong, You must put all your Database connection in the dataModule.

You shouldn't use ServerController .

[mierlp]

Hi Ronny,

 

I use this concept because when the applications is started...i use a .ini file which contains

the database server ip, username/password and other entries for UniServerModule

 

At this point i can use the uniServerModule.OnBeforeInt to set :

 

uniServerModule.AjaxTimeOut

uniServerModule.ServerMessages

 

This is done on some advize from Farshad in the past.

 

I will try to separete the properties i need for the uniServerModule

and read the database section of this .ini files to initial the variables for the myConnection.

 

Regards

[Farshad Mohajeri]

On the servermodule i put the MyConnection component

 

 

No! Put it on MainModule or a DataModule.

[rencarnacion]

Use .INI file too but use these code in the Oncreate of DataModule 

 

    dbConecta.Close;

      dbConecta.Params.LoadFromFile(UniServerModule.StartPath +

    '\Files\dbConecta.ini');

    dbConecta.Open();

[zilav]

No! Put it on MainModule or a DataModule.

 

Speaking about connections and datamodules, what you can advise for DB connections pooling in UniGUI?

[Farshad Mohajeri]

Speaking about connections and datamodules, what you can advise for DB connections pooling in UniGUI?

 

DataModule Pooling is in the todo list. Some preliminary works have been done.