[Gambas-user] Adding results from different databases

KKing kicking177 at gmail.com
Fri Dec 23 10:43:41 CET 2022


>     I want to add results (with same fields) from different databases
>     to one initial result.

As ever it depends on amount of data, is it static or fast moving data, 
how you want it presented etc.
If you want it to really be a data bound gridview then unless the 
databases can be linked to allow some sort of union then you are going 
to need to stage the data somewhere to provide the table/query to bind 
to. Either import both results into a local db (maybe sqlite) which 
would give your UI more performance or a staging table on one of the two 
db's you have, obviously the data will become stale until refreshed.
Otherwise do not databind and just manually populate the gridview.
K.


More information about the User mailing list