Legacy Application Modernization: Key Steps, Benefits & Best Practices
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
SQL_ENABLE_RECONNECT allows the MySQL Driver to automatically reconnect to the server after the connection has been closed by a time-out. In the MySQL my.ini file you can set a system variable called wait_timeout to set the number of seconds that the server will wait on a non-interactive connection before it closes the connection. The default value for this variable is 28800 (8 hours). See also the MySQL manual under Server System Variables and more specifically the variables wait_timeout and interactive_timeout.
Syntax
SQL_ENABLE_RECONNECT of <ServerName> to dftrue/dffalse
Argument Explanation
sServer Server Name.
bstate True/False - DFTrue/DFFalse.
Example:
#include mertech.inc
String sServerID
String sUser
String sPassword
Integer bStop
Move "YourServerID" To sServerID // Server ID or IP number
Move "user" To sUser
Move "password" To sPassword
Login sServerID sUser sPassword MYSQLFLEX
SQL_ENABLE_RECONNECT Of sServerID To dftrue
Open Customer
Clear Customer
Move (false) To bStop
While not (bStop)
find Gt customer by index.1
showln "Customer: " customer.customer_number "-" customer.name
// Selecting "No" makes bStop return True
Get Confirm "Do you want to find the next record?" To bStop
Loop
Send Info_Box "Hello World" "VDF Basic Application"
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...