AnsweredAssumed Answered

ODBC SQL Server - more frequent updates from SQL connection

Question asked by DavidMansfield_2 on Feb 22, 2016
Latest reply on Feb 23, 2016 by macwombat

Hi,

 

We have a FileMaker server that has a ODBC Connection to a SQL server on another computer.

My database is server hosted and read's data from the SQL server and I use FileMaker to sort and display the data only.

 

My problem is that the data is not often very up to date, and I don't know how to fix this.

 

Is there a way that in a script I can perform a request that filemaker checks for records from the SQL connection?

I don't have any SQL experience just to be clear, I am simply trying to use FileMaker to get data from a door entry system we have and it all works apart from if i need to run a report in a fire alarm situation and need the records to be as up to date as possible,

 

Thanks.

Outcomes