7 posts in this topic
SQL novice - where to start?
A simple project wants to start with several people out in the field doing data entry; in the interest of uniformity, I set up a simple one-table web-based SQL table with a one-way PHP interface. That's working fine (and is about the limit of my facility with PHP). My intent was to set up an automated recurring import into a FMP database, which I thought would consist of entering credentials and an IP address into the ExecuteSQL script step. I find the learning curve a little more steep.
In this instance, it's really not hard for me to export the contents to my desktop once a day and then hoover them up into FMP. But can you recommend a one-stop tutorial for this kind of straightforward behavior?
SQL Server 2008 ESS - Only displays system tables
This is my first post in the forum - one of no doubt many to come!
I'm working on my first solution and as part of that I'm pulling in data from a SQL Server 2008 database which will be augmented by file maker tables.
I have been able to locate the DSN and setup the External Data Source, however when I try to add the table in the relationships screen I can only see the system tables in the SQL database - not the views and tables that I have setup.
Does anyone have an idea of a possible solution for this?
Running FileMaker Pro Advanced 14 on Windows 7.
ExecuteSQL - Field cannot be found
By Pat Fellows
I am extremely new to working with SQL, so i am currently fumbling my way through achieving my required outcomes.
To explain further explain my issue, i created a table/layout on one of my databases that i could use to practice and visualize the outcomes of ExecuteSQL.
I type into my "query" field and that drives a separate ExecuteSQL calculation.
I have been able to achieve the required outcome in this field, however when i transfer the query directly into a ExecuteSQL calculation i get errors. These relate to the field in financials called "Cost Code"
If i attempt the same calculation without it, i can run it without an issue. However what confuses me is it will work when input through a query field.
Where "Cost Code" = 'FA' and EID = '982 000147908607'
Please find attached images highlighting and showing everything relevant.
ExecuteSQL() sums and group by ERROR...
Trying to figure something for a fellow lister. I am tring to run a query in FileMaker using ExecuteSQL() that works perfectly when I run a similar query in a normal SQL editor:
SUM(i.Quantity) AS sQTY
FROM invoice_invoicelines_Product p
JOIN invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY p.pk_ProductID
It produces a "?" (which is very informative).
I guess need to know if this is too much for FileMaker's SQL engine or if FileMaker is going to force me to use something that is not tradition SQL protocol/syntax.
Any feedback would be appreciated.