Please help me understand something:

Say you check the SQL Connection (as you indicated) using SQLEXEC(Applic.SQLHandle, "") and then, if it fails,
you run the code that calls SQLIDLEDISCONNECT(). Here is how I understand it:

if SQLEXEC(Applic.SQLHandle, "") < 0
   ASQLHANDLES(aSqlhndls)
   FOR EACH nOdbchdbc IN aSqlhndls
           =SQLIDLEDISCONNECT(nOdbchdbc)
   ENDFOR
endif 

After the above code, if I understand correctly, all SQL Server connections are disabled. So, the application need to reconnect to the SQL Server.

Then you say:
>>Each time a connection fails, you can call a routine with these statements and it will reconnect upon the >>next usage of the connection.

How does the application RECONNECT the CA?

You also wrote:
>> If it fails, it will first try to reconnect, after which if succesful would refresh your records just fine.

Again, what I don't understand is how does CA RECONNECT? What specific code RECONNECTs the application to the SQL Server?

TIA