>>>
>>>Yes,
>>>There is a very little chance the connection to drop during these milliseconds until all biz classes instantiate.
>>
>>I like your idea. I am considering adding this call (as per code you suggested) in the LOAD method of the base form used by all forms. I suppose if the connection is not valid in LOAD method (SQLEXEC returns .F.) the code will have to call a routine to create a new connection. I wish I could "force" this condition (that is force Communication link failure) on my computer to see how the program will react.
>>Thank you for your suggestions.
>
>
>Stop the service (if SQL Server is local) or unplug the LAN cable :o)
Thank you for the suggestion.
The SQL Server is local so I will stop the service. But I wonder what actually happens on the customer SQL Server; as far as I know, nobody stops the server. And I doubt that they unplug the LAN card. Yet, I get these messages "Communication link failure."
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham