Help with executeSQL and Like ?

[JoVac]

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

[beverly]

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.

[JoVac]

Thank you it work.  

And next time I'm posting I'll do like you said.  

 

Jo