Apologies in advance if this is a vague question, or if it's been extensively documented, but I could do with some basic advice on moving filemaker tables to SQL. In terms of database development, I have only really known FileMaker.
We have a 60 table, 25 user FileMaker database which takes care of most if not all of the company's operations.
There is now talk of allowing other platforms (such as PowerApps/PowerBI) access to the data. One such reason is other people are interested in making apps/applets that serve specific functions. This would be simple if the data were held on a SQL database.
So if all the FileMaker tables were to be moved to SQL, what sort of a task is that in terms of keeping the existing FileMaker gui functioning?
Or. is there a simpler way to grant other platforms access to filemaker tables?
And of course, what are the downsides?
Looking for someone to help setup a simple connection to a sql database on cpanel for our Ranch to connect to cattle listings on our website.. I'll be using fmp12 server or content for now just establishing a connection via fmp12 client on windows 7 pro machines.
Specifically I am having trouble establishing a DSN connection from any of my machines and have opened ports / given access in cpanel to my static IP.
I have also updated MS ODBC drivers on one of the machines to see if that made a difference. It may be something quick for an expert with experience or it might end up being a gremlin.
I have set up some test databases for troubleshooting purposes and willing to do alot of the legwork if i'm able but also willing to pay someone for their expertise as well.
I am in the process of connecting an existing FileMaker database to a SQL server that is behind a web interface. I wanted to know if there is a way to send a command from the web interface to kick off a sync.
For example, a user opens a record on the web, makes some changes, hits a save button.
How do I get that "Save" to trigger a sync?
And can I get it to sync that single record or do I need it to sync all records that have changed?
Thanks in advance,
By Eli Walker
I'm trying to use execute sql to populate a field with the sum of all the values in a field of related records. All I get is a ? so obviously something is wrong with my syntax but I cannot figure it out. Any help much appreciated! This calculation is occurring within the 'Collections' table.
Let ( [
query = "
FROM \"Straws_for.entry\" AS S
JOIN \"Animals.to.Collections_join\" AS A
ON \"S.fk_a.to.c.join\" = \"A.pk_join\"
WHERE \"A.fk_collection\" = ? " ;
collection = Collections::pk_collection ;
result = ExecuteSQL ( query ; "" ; "" ; collection)
] ; result )
Also, after some reading on similar threads I see people suggest not using this function in a calc. field... if there's any better way of doing it I'd love to hear it. Thanks for the help, really appreciate it.
I'm trying to export my filemaker records to my external sql database via the execute sql script step but am getting a number of errors.
I can see my external ODBC source and can generally write to it (I can go to the respective layout and click 'new record'). My query basically as follows:
"INSERT INTO dbo.Log ( dbo.Log.log_id, dbo.Log.log_case_idf, dbo.Log.Labour_TOTALS_Labour_Cost, dbo.Log.Labour_TOTALS_Item_Sale) SELECT Log_Log.log_id, Log_Log.log_case_idf, Log_Log.Labour_TOTALS_Labour_Cost, Log_Log.Labour_TOTALS_Item_Sale, FROM Log WHERE Log_Log.Log_Type = '2'" My first question is: is it even possible to export to an odbc source with a 'insert INTO SELECT' query?