Get functions with execute sql

[charlest]

Is it possible to use Get functions within execute sql statements such as...

 

ExecuteSql("

 

SELECT dept_t

 

FROM employees

 

WHERE employee_id = ?"

 

; ""; ""; Get(AccountName))

 

I have tried this statement and I can't get it to evaluate in the data viewer.

[eos]

Is it possible to use Get functions within execute sql statements […]

 

You can use whatever you like to build a string which is a valid SQL statement, including native Filemaker functions as parameters (taking into account the usual caveats as context and [in the case of Get() functions] stored vs. unstored, etc.).

 

Here is your function used verbatim:

 

 

[…] I have tried this statement and I can't get it to evaluate in the data viewer.

 

Did you get an error, or an empty result?

[charlest]

Empty Result

[Wim Decorte]

empty result means that there is no syntax error but that there is really nothing found.

 

I would capture the Get(AccountName) in its own variable and use that variable in the SQL query.  Much easier to troubleshoot.

 

Remember that SQL is case sensitive.  So if the data record has "Wim" but I log in with "wim" then there will be no match.

The FM account names are not case sensitive.  So you may want to convert your data to all lower or all upper case and do the same with the result of the Get(AccountName) function,

[charlest]

Thanks.  That was it, the case sensitivity.