mierlp Posted April 1, 2014 Share Posted April 1, 2014 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 Quote Link to comment Share on other sites More sharing options...
rencarnacion Posted April 1, 2014 Share Posted April 1, 2014 I guess your Wrong, You must put all your Database connection in the dataModule. You shouldn't use ServerController . Quote Link to comment Share on other sites More sharing options...
mierlp Posted April 1, 2014 Author Share Posted April 1, 2014 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 Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted April 1, 2014 Administrators Share Posted April 1, 2014 On the servermodule i put the MyConnection component No! Put it on MainModule or a DataModule. Quote Link to comment Share on other sites More sharing options...
rencarnacion Posted April 1, 2014 Share Posted April 1, 2014 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(); Quote Link to comment Share on other sites More sharing options...
zilav Posted April 2, 2014 Share Posted April 2, 2014 No! Put it on MainModule or a DataModule. Speaking about connections and datamodules, what you can advise for DB connections pooling in UniGUI? Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted April 2, 2014 Administrators Share Posted April 2, 2014 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.