3 Replies Latest reply on Feb 23, 2016 6:45 PM by macwombat

    ODBC SQL Server - more frequent updates from SQL connection

    DavidMansfield_2

      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.