AnsweredAssumed Answered

Updating ESS shadow tables

Question asked by RafaelCaballe on Jun 23, 2016
Latest reply on Jun 29, 2016 by RafaelCaballe

Hello,

 

I'm working on a solution that needs to gather some information from a MS SQL database. I have set up the proper driver on FMS, defined de DSN and get the shadow table in the Relationship Graph. The MS SQL table is very straight forward: a single record with 10 fields which contain numeric values that are updated every second. The numeric values are counters which are update by an SCADA system.

 

From FileMaker I have set up an OnTimer script, to read, every second, the values of the fields in the MS SQL table. The purpose is to show in a layout the current counter value, as information of the manufactured units (that is what the counter means).

 

The fact is that the ESS table is not updated, as I expected, so I do not get the correct information.

 

Is there any means to get this ESS shadow table updated?

 

Thanks.

Rafael

Outcomes