Jump to content

ExecuteSQL question


This topic is 2820 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 = "" ?

Link to comment
Share on other sites

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:

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

Link to comment
Share on other sites

This topic is 2820 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.