Than you Gordon I will try this.
>Our application that we develop contain code to help with this situation.
>
>Basically you already have a connection to the database open. I don't think you are creating a new connection for every query into whatever database. You don't need to either, except when you have problems like this. For example:
>
>* Connection is already open and has been used x number of times before.
>lnResult = SQLEXEC()
>IF lnResult > 0
> * you already handle this stuff
>ELSE
> * connection may be busy, bad, whatever...
> * you didn't get what you should have
>
> * create a new connection - no one said you couldn't
> lnHandle = SQLCONNECT()
>
> * re-execute the query or command
> = SQLEXEC()
>
> * don't forget to clean up after yourself
> * this is only a temporary connection
> = SQLDISCONNECT()
>ENDIF
>
>Generally you only need to try twice, so a loop will be unnecessary.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement