coolcat Posted July 9, 2016 Posted July 9, 2016 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 = "" ?
schamblee Posted July 9, 2016 Posted July 9, 2016 Take a look a sql explorer from seedcode http://www.seedcode.com/filemaker-sql-explorer/ 1
comment Posted July 9, 2016 Posted July 9, 2016 4 hours ago, coolcat said: how do I search for field = "" ? I believe you need to say: WHERE YourFieldName IS NULL 1
Wim Decorte Posted July 9, 2016 Posted July 9, 2016 http://www.soliantconsulting.com/blog/2013/11/executesql-and-empty-values 1
coolcat Posted July 9, 2016 Author Posted July 9, 2016 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.
Recommended Posts
This topic is 3311 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now