Hello, I’m trying to create a grid to display information. However, I need to use two different data sources. Can I use UNION ALL to combine these two different sources?
hi
yes, i have some grids with union
regards.
1 Like
But Do I have to specify the sources?? for example One part of the data Im taken form sql and the other form mysql
hi
sorry I didn’t undestand you. I think you can’t do it from different sources o databases.
may be you can use a view that includes data from 2 or more sources, and then use the view as a source of the grid.
regards.
You must create another connection into your project from menu Database->New Connection and after you can use the two tables in UNION clause
Create a new table on the fly with the result of the query of both sources and base the grid on that. Base the grid on that temporary table and then populate it in application init.