SQL SI...
Posté par Chapeau_m le 18/9/2009 9:19:48
Bonjour,
Comment écrire ceci en SQL:
Patienten.Naam = LIKE %{Param1}%
AND Patienten.Naam SOUND LIKE {Param1}
AND Patienten.Naam SOUND2 LIKE {Param1}
AND Patienten.Geboortedatum = {Param3}
---
SI (Patienten.Naam = LIKE %{Param1}%) = "" alors (Patienten.Naam SOUND LIKE {Param1})
SI (Patienten.Naam SOUND LIKE {Param1}) ="" alors
(Patienten.Naam SOUND2 LIKE {Param1})
AND Patienten.Geboortedatum = {Param3}
---
BAV
Comment écrire ceci en SQL:
Patienten.Naam = LIKE %{Param1}%
AND Patienten.Naam SOUND LIKE {Param1}
AND Patienten.Naam SOUND2 LIKE {Param1}
AND Patienten.Geboortedatum = {Param3}
---
SI (Patienten.Naam = LIKE %{Param1}%) = "" alors (Patienten.Naam SOUND LIKE {Param1})
SI (Patienten.Naam SOUND LIKE {Param1}) ="" alors
(Patienten.Naam SOUND2 LIKE {Param1})
AND Patienten.Geboortedatum = {Param3}
---
BAV
Cette contribution était de : http://old.wdforge.org/newbb/viewtopic.php?forum=20&topic_id=6274&post_id=24923