[Gambas-user] Adding results from different databases
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.
More information about the User