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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only