Hi

We have a small app that displays a grid of data using IBO components.
When laptop users disconnect from their base station and therefore move
from a wired Lan to a WIFI netork the Firebird connection is broken.
What is the recommended / best way to gracefully handle this situation
and seamlessly return to normal?

I had though something like the following

1. Detect disconnect by trapping exception or AfterDisconnect event

2. Loop attempting to reconnect for a specified period (30seconds ?)

3. If reconnect successful, reopen all queries using the last SQL and
settings. I would like to show the same records if they have scrolled
through the grid but I am aware this might not be possible.

4. If reconnect unsuccessful show message and allow for close or retry.

What do people think?


Thanks
Rob