Select Query with input variable

CloverDX Platform
1

Hi guys,

Im trying out an select statement, so i can see what primary key certrain varaibles got. How do i do this? I have tryed it with the DBExecute. This give the following error
SELECT via executeUpdate(). I also tryed the DBJoin, but cant figure out how to use the input variables on the ? places.

SELECT $PatientID:=patient.PatientID, $BehandelaarID:= behandelaar.BehandelaarID
From patient , behandelaar
WHERE patient.Naam = ?
  AND behandelaar.Naam = ?
2

Hi Faldarod,

The best way to implement what you are attempting to do is using LookupJoin. Question marks in query are automatically replaced by values from fields specified as Join key in respective order.

The attached graph illustrates that. You will just need to configure connection to database and provide some meaningful data in DataGenerator. I split the query into two queries - one for patient and another for behandelaar. Otherwise you would get cartesian product of the tables which I do not suppose is what you expect.