I have one form open 24/7 and a global connection hanlder open from the main program (lnConn)from time to time the SQL Service become unavailable (please do not focus on this problem cause i am not trying to solve this) due to this, the lnConn becomes useless the form tries to read and write data to back end from time to time using SQL Passthrough like lnSQLResult = SQLEXEC(lnConn,"select * from table")
i know if lnSQLResult is -1, this means something went wrongI know aerror retrieves the error from the SQLEXEC
I Know element 1,1 is a Error Code
I know element 5 is a error code too
my question to you guys is the foloowing: what are the codes i have to test in order to know that there is a broken link between the computer and the SQL Server??best regards
.......
DO WHILE .T.
ME.Work()
ENDDO