Hi,

Using FP9 Pro and MySQL with ODBC as the external data source on
Windows Vista.

I have been trialling the use of FP9 with external data sources but I
wondered how you develop an FP application to overcome the need to
Refresh Window to see data that has been added externally to the MySQL
database.

I am new filemaker and would like to know if these options are
feasible:

1. Set a timer that every X seconds performs Refresh Window command.

2. On the opening of a new layout perform the Refresh Window command.

And finally any experience reports that you have with external data
sources would be useful.
--
Edward Stow

"Edward Stow" <ed.stow [at] gmail.com> schreef in bericht
news:1186694987.270453.164690 [at] i13g2000prf.googlegroups.com.. .
> Hi,
>
> Using FP9 Pro and MySQL with ODBC as the external data source on
> Windows Vista.
>
> I have been trialling the use of FP9 with external data sources but I
> wondered how you develop an FP application to overcome the need to
> Refresh Window to see data that has been added externally to the MySQL
> database.
>
> I am new filemaker and would like to know if these options are
> feasible:
>
> 1. Set a timer that every X seconds performs Refresh Window command.
>
> 2. On the opening of a new layout perform the Refresh Window command.
>
> And finally any experience reports that you have with external data
> sources would be useful.
> --
> Edward Stow
>

For timers you have to look for one of the (free) plug-ins
like: http://www.myfmbutler.com/index.lasso?p=416
or the zippscript plug-in at:
http://homepage.mac.com/jkornhaus/filemaker/plugins.html

Use a navigation button to go to different layouts. Let the button fire a
script. This goes where you need and then refreshes. Just as a hint. always
use buttons with a script. If you just attach one function (like goto
layout) you surely want to add a second function to the button and need to
built a script anyway.

No experience with SQL or OBDC....

Keep well, Ursus