Good afternoon Gaetano,
> finally, you can use the above either in a form/report by dropping it on
> the designer surface, just be aware that the connection to the server
> will time-out, so in a form, you may need to reactivate the connection
> before using the ADOQUERY objects because you cannot control when the
> user will click the button, example:
>
> //reestablish database connection
> form.adodatabase1.active=null
> form.adodatabase1.active=true
On a local network using MariaDB 10.3/10.4 I have not faced this issue.
You need to set the options value to include option of autoreconnect.
For internet i cannot say.
Regards
Akshat
|