[Gambas-user] Error ODBC
chrisml at deganius.de
Thu Jul 15 11:04:24 CEST 2021
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.
Dies ist keine Signatur
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 840 bytes
Desc: OpenPGP digital signature
More information about the User