I am considering conversion of my backend from VFP to SQL Server.

This is an application with over 700 views from approximately 50 tables in a single database.

It is a financial application. Portions are executed from roaming wireless workstations. We do have many disconnect problems with these wireless workstations. We have it under control for existing installations (usually), but each new installation seems to have it's own unique issues when getting the wireless network to become stable.

In case it matters, my application (the executable) is running locally on the client and the server is where the database resides, probably the most common setup.

My question is very specific. It effects my priority with regard to switching from a VFP engine to SQL Server.

Question:

Using FoxPro as the database engine, my application is running. A list of accounts is on the user's screen. The user isn't doing anything. No key or mouse activity is occurring. The foxpro code would be sitting on a READ EVENTS line. At least 10 views are probably open.

I reach and disconnect the ethernet network cable, leave it disconnected for 5 seconds, then plug it back in.

The user clicks the Requery button and the app crashes because a disconnect had occurred even though it is now re-connected. Yes I can and do capture the error and inform the user that the app can not recover from the disconnect and will basically crash. I do not expect to ever find any reasonable method to fix this while using VFP as the database engine.

This is normal FoxPro behavior. I understand that. I accept that.

This crash will NOT occur once I switch to SQL Server backend because there would be some means to just reconnect to the database or something like that.

True or False?

Thanks,
John