[Gambas-user] Adding results from different databases

[T Lee Davidson]

On 12/22/22 11:05, Safiur Rahman wrote:
> Hi
> I want to add results (with same fields) from different databases to one initial result.
> For example
> I have one large result populating gridview using _Data method. When I click a button another large result gets added to the 
> first result and scrolling gridview also shows result from second database also.
> 
> Is there any method to achieve this?

Is there any reason you can't simply append new rows to the gridview without trying to combine the actual query Result objects?

And, is the data in distinct databases, or in different tables of the same database? If just different tables, the SQL JOIN 
operator may help.


-- 
Lee