ESS Detect deconnection

[Frankywinky]

Hello

I am using a ESS in FileMaker Pro over a SSH tunnel to a MySQL database (it works really fine!). But sometimes, my SSH connection may drop, by example, because of the network state.

I've made a calculation field that ask a value on a remoted single row table, so it could say "Connected" or "Disconnected" whenever the ESS connection is up or not. This could be great for the users so they know if they should reload the file and for scripts to detect that tables are not in a normal state.

However, FileMaker seems to cache the value and it does not update when my connection drop. Anybody know a easy workaround?

Thanks !

Frankywinky

[bcooney]

Is the calc unstored?

[Frankywinky]

Yep! Sorry I didn't mention it.

But it seems only to update when we open the file and or we edit the database structure...

Edited January 12, 2009 by Guest
edit the database [structure] (no ambiguity)

[Frankywinky]

Other observation :

If I use "refresh window" on a window where the calculation field is shown, it goes to "Disconnected"

If I ask the value on a script, it is not updated.

If I add the random function number after the condition (by example "Connected .322763"), the random number is updated each time it is shown, but not the "Connected" information.

Here's my calculation

If ( TestConnection::id = 1 ; "Connected" ; "Disconnected" )

Where

TestConnection is an alias to a MySQL table containing one field (id) and one row (with the value 1).

Any ideas ?