Hi all,

Curious about ExecuteSQL

this works...

ExecuteSQL ( "SELECT myfield FROM myTable WHERE myTable.color = ? and myTable.style = ? and myTable.id = ?" ; "" ; "" ; 
"black" ; "test" ; "3" )

but this fails... when I replace myTable.color selection from "black" to empty string "" then the result fails (when there are rows with this criteria)...

ExecuteSQL ( "SELECT myfield FROM myTable WHERE myTable.color = ? and myTable.style = ? and myTable.id = ?" ; "" ; "" ; 
"" ; "test" ; "3" )

Q: any reason it fails? is it a syntax thing? how do I search for field = "" ?

Take a look a sql explorer from seedcode http://www.seedcode.com/filemaker-sql-explorer/

4 hours ago, coolcat said:

how do I search for field = "" ?

I believe you need to say:

WHERE YourFieldName IS NULL

 

http://www.soliantconsulting.com/blog/2013/11/executesql-and-empty-values

9 hours ago, schamblee said:

Take a look a sql explorer from seedcode http://www.seedcode.com/filemaker-sql-explorer/

Wow - This is great - I had not seen this before - thanks!

8 hours ago, comment said:

I believe you need to say:

WHERE YourFieldName IS NULL

 

Thanks Comment - sounds right - I will give it a try.

2 hours ago, Wim Decorte said:

http://www.soliantconsulting.com/blog/2013/11/executesql-and-empty-values

Thanks Wim - this is a perfect example - Thank you for this link.