Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Practical uses for SQLIDLEDISCONNECT()
Message
De
23/08/2022 19:27:31
 
 
À
23/08/2022 14:35:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01684846
Message ID:
01684860
Vues:
42
Thanks Thomas. I've never done a "check connection" before, and I don't guess where SQLIDLEDISCONNECT() fits. Please, coud you give me translate what you advice me into a small piece of code?

TIA


>Check connection before doing anything and reestablish on error.
>If this slows down your app, chances are you coded chatty, not chunky and might rewrite parts.
>
>>Hi. I have a problem with remote users randomly losing their VPN connections to a SQL Server database, (by the way, I use remote views on all my apps).
>>
>>I was searching the VFP Help but didn't find any function or command that would help me avoid the errors and allow me reconnect the view somehow within the app.
>>
>>While I was searching the help file I found the SQLIDLEDISCONNECT() function, which I don't get how that could be used. Perhaps to solve my proble? But I don't see how. Any help would be much appreciated.
>>
>>TIA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform