Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Practical uses for SQLIDLEDISCONNECT()
Message
From
23/08/2022 19:27:31
 
 
To
23/08/2022 14:35:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01684846
Message ID:
01684860
Views:
41
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
Previous
Reply
Map
View

Click here to load this message in the networking platform