[Gambas-user] Error ODBC

[Christof Thalhofer]

Am 15.07.21 um 02:12 schrieb PICCORO McKAY Lenz:

> but gambas has a lack of anidation for resultsets and sql execution.. 

???

> for example i must close the previously opened connection to perform 
> another query.. if the previously do not finish and must  free the 
> connection object!
A connection always hangs as long as the current sql order is not 
finished. This is the same in every language. If you want parallel 
execution of sql orders you have to keep up multiple connections at the 
same time. This is called connection pooling.

But you can keep the db connection up in Gambas as long as you execute 
the sql orders in serial order one after the other.

In my client programs usually one connection to the database is started 
at the beginning in a singleton and then used over and over until the 
program stops at the end.

Alles Gute

Christof Thalhofer

-- 
Dies ist keine Signatur

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 840 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20210715/01899bb7/attachment-0001.sig>