Database of different branch of our company is on their own on the server, and database table structure is the same, the content is different, now I want to be a general control system, in a total interface can see all the records of a business branches of the same, such as: I can see all open the interface branch sales record, and then by clicking on a record, you can find the record from the corresponding database detailed information,
Cross-database this how to do it, please? Excuse me is to use the SQL statement is easier, or a certain Delphi control operation?
Thank you very much!

CodePudding user response:

You use different database link control to the different database, and add their data to a clientdataset, using the grid even the clientdataset to different database records show in a grid, had better add a field in the clientdataset, the the value of the field shows that this article take the record from which database, so you can according to the field to see the details of the corresponding database,

CodePudding user response:

Upstairs is

CodePudding user response:

reference 1st floor Playmaster response:

you use different database link control to the different database, and add their data to a clientdataset, using the grid even the clientdataset to different database records show in a grid, had better add a field in the clientdataset, the the value of the field shows that this article take the record from which database, so you can according to the field to see the details of the corresponding database,

Support, this method is very good,