youngsnowrider

I have been having the same trouble ... I tried everything above. It only stared working when I copied the server.pem file from another computer running filemaker and copied to the computer with the problem. good luck

So are you saying this is impossible in version 9?

I have the same question. Is it possible to create a script that will run a SQL query and then store the result in a FilMaker9 field. My SQL database is a lot more complicated than my Filemaker Database, and they are not always connected. This could be done making all of the connections using relationships in FM, but this seems tedious for a little bit of information. most of the time I just query to excel and then import my data. Thanks

I have several fields that have a number stored, 1-6, I want to know how I can total or cout how many times "1" was selected. Database: Student Misbehaviors Table: Each Incident Field Student_Behavior -- Number (recorded 1-6) Each number means…. 1 = Physical Contact 2 = Foul Language And so on I am making a report and want to know how many times a 1 was recorded in this field. P.S. The Field was designed this way because that’s how the data is imported.