[Gambas-user] Adding results from different databases

[BB]

On 23/12/22 2:12 pm, Safiur Rahman wrote:
> Thanks
>
> 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:
>
>     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?
>
>
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.

b

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20221223/fe7c39fe/attachment-0001.htm>