Jump to content

Help with executeSQL and Like ?


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

Recommended Posts

  • Newbies
Développeur SupportSolution Starter
Développeur Support 21 juin 2016 08:53

I am working on a search query with "Like ?"  The query give me no result  when I put the search string in a field but If I try with the same value in a constant I have my result. 

Here are the two query:

 

ExecuterSQL ( "SELECT \"idDossier\"

, \"Demandeur\"

, \"Historique\"

, \"TravailDemandé\"

FROM DemandeAssistance

WHERE

  \"Historique\" LIKE ?

OR \"TravailDemandé\" LIKE ?" ; $$separateurChamp ; $$separateurLigne ; RechercheGlobale::chaineComposée ; RechercheGlobale::chaineComposée )

 

ExecuterSQL ( "SELECT \"idDossier\"

, \"Demandeur\"

, \"Historique\"

, \"TravailDemandé\"

FROM DemandeAssistance

WHERE

  \"Historique\" LIKE ?

OR \"TravailDemandé\" LIKE ?" ; $$separateurChamp ; $$separateurLigne ; "%Roxanne%" ; "%Roxanne%"

)

 

Thanks for your help,

 

Jo

Link to comment
Share on other sites

this has been asked and answered:

https://community.filemaker.com/message/581184

beverly

p.s. if cross-posting (posting the same question on more than one forum), please notify the others that you are doing so (typically with [x-post] in the subject). It prevents duplication. And if answers are achieved on one, but not the other, it is polite to post the correct answer on all forums where the question was asked, since not all people are on all forums. :)

  • Like 1
Link to comment
Share on other sites

This topic is 2836 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.