dbTalk Databases Forums  

FM meets MySQL sync problem

comp.databases.filemaker comp.databases.filemaker


Discuss FM meets MySQL sync problem in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Harry
 
Posts: n/a

Default FM meets MySQL sync problem - 11-18-2010 , 05:51 PM






I just made a link between a MySQL database and a Filemaker database.
I can reed information within Filemaker(FM) from the MySQL table. I
even can change the contents in a field in FM that fysically is in
the MySQL file.
But I do not see the changes directly. Only after closing and
reopening FM the field is realy changed. Is there a way to synchronise
the MySQL record? Maybe in FM or in MySQL?
Thanx for any help. Harry

Reply With Quote
  #2  
Old   
Your Name
 
Posts: n/a

Default Re: FM meets MySQL sync problem - 11-18-2010 , 06:17 PM






In article <fgebe6l1speojbfg4mub3mggivb4ebq3md (AT) 4ax (DOT) com>, Harry <a@b.c> wrote:
Quote:
I just made a link between a MySQL database and a Filemaker database.
I can reed information within Filemaker(FM) from the MySQL table. I
even can change the contents in a field in FM that fysically is in
the MySQL file.
But I do not see the changes directly. Only after closing and
reopening FM the field is realy changed. Is there a way to synchronise
the MySQL record? Maybe in FM or in MySQL?
Thanx for any help. Harry
I'm not sure if it's the cause of your problem, but newer versions of
FileMaker have a "feature" where data isn't actually saved like it used to
be when changes are made. You may have to somehow incorporate FileMaker's
Commit command to actually save out changed data.

Helpful Harry )

Reply With Quote
  #3  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: FM meets MySQL sync problem - 11-18-2010 , 06:43 PM



On 11/18/2010 3:51 PM, Harry wrote:
Quote:
I just made a link between a MySQL database and a Filemaker database.
I can reed information within Filemaker(FM) from the MySQL table. I
even can change the contents in a field in FM that fysically is in
the MySQL file.
But I do not see the changes directly. Only after closing and
reopening FM the field is realy changed. Is there a way to synchronise
the MySQL record? Maybe in FM or in MySQL?
Thanx for any help. Harry
The data you are viewing in FileMaker is cached for speed of viewing.
You can add a Refresh [flush cache] button to the layout, or add such a
script as a layout script trigger when changing records, or a timed
script trigger that refreshes every x seconds as needed.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker Certified Developer
Associate Member, FileMaker Business Alliance

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.