"......WHERE \"_kf_uuid_companys\" = ?", "", ""; $additional_settings)
Is this what you are looking for?
Thank you very much for the reply.
Unfortunately i cannot get it to work. I am very very new to the SQL side of things.
When adding your where statement i am getting the message that an operator is missing.
I have attached three screenshots to show how i have added the statement, the error displayed, and the highlighted area from the error....
first I need to clarify:
1. are you looking at a SQL database and sending an Import records script step?
2. are you looking at FMS as a SQL source and issuing a query to it?
3. are you trying to write an ExecuteSQL() function to a table occurrence (table alias) that you have on your FileMaker Relationship graph?
There is not enough information, can you supply a little more, please?
Thanks for taking the time to have a look at this.
I have a filmmaker database which is hosted on Filemaker Server. I am now getting into allowing users to add data from mobile devices and as such the mobile devices need to sync to the server.
The mobile device asks a script to be performed on the server to do an SQL query on the data to ensure that the correct data is sent back to the mobile device.
If the one line under the //BIGTOMS addition is removed then the sync does work. However information is sent back to the mobile device for all companies stored rather than the individual company that the mobile user wants the data of.
I am looking for an addition to the above calculation to further narrow down the data to only include only the data relevant to the company that the user is interested in.
I hope that this makes sense.