Execute SQL Simple Query

Question

I have a simple query that I'm sure anyone whos not a novice will be able to easily solve, I have a table which has a bunch of 'tags' for instagram. I am trying to extract TAGS where DATE = today.

A rough copy of what I want is shown below, I know the syntax is incorrect which is why I'm struggling, but I think you can see what I'm trying to achieve, any advice welcome :)

ExecuteSQL 

(  

SELECT IGs::tag 

FROM IGs:: 

WHERE IGs::creation date = 22/10/2048

;)

However I would prefer that creation date = $$todaysdate ( I will set the variable before the ExecuteSQL in the script.

community.filemaker.com/thread/164798

Nae
– Nae

2018-10-22 15:33:38 +00:00
Commented Oct 22, 2018 at 15:33 — Nae
– Nae, Commented Oct 22, 2018 at 15:33

AndreasT · Accepted Answer · 2018-10-22 17:35:52Z

1

You need to use quotes around the query. Something like this.

ExecuteSQL 
(  
    "SELECT tag 
    FROM IGs 
    WHERE \"creation date\" = ?"
    ;"";"";$$todaysdate
)

answered Oct 22, 2018 at 17:35

AndreasT

2,3251 gold badge18 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sean Over a year ago

Andreas coming to my aid once again! I owe you a beer mate! That's cracked it, thankyou once again.

AndreasT Over a year ago

No problem @Sean, glad to help. Be aware that FileMaker's ExecuteSQL is fragile and breaks easily if you later change a field name or table name. There are many ways to work around that, my favorite way is to use a couple of custom functions that takes advantage of FileMaker's built-in robustness against such things and also handles quotes automatically. More on those here

Collectives™ on Stack Overflow

Execute SQL Simple Query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related