[Gambas-user] Adding results from different databases
adamnt42 at gmail.com
Fri Dec 23 04:53:35 CET 2022
On 23/12/22 2:12 pm, Safiur Rahman wrote:
> I am talking of results from two databases.
> It would be better if there is some procedure to convert result to
> Variant or Json without enumerating each record one by one. Like
> Result.All() for all fields
> On Thu, 22 Dec 2022, 21:50 Safiur Rahman, <isafiur at gmail.com
> <mailto:isafiur at gmail.com>> wrote:
> 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?
Are they the same rdbms? Maybe, for example in postgres, you could build
a foreign data wrapper to get a union of the two queries. By the way
since you are using large data sets then a full result->array transfer
would probably be slow anyway.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the User