JoVac

I have two tables, the first table is the master and the second table is the details. Each record of the Details is related to an ID in the first table. What I want to do is display in a model all the records from the details table. My problem is that instead of display a list of all details records He displays one by page. I have two loops. I've tried a lot of combinations and nothing work. Thanks for your help. Johanne

Thank you it work. And next time I'm posting I'll do like you said. Jo

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