hi all,
i'm new to powerbuilder (10) and i have a question.i have made the following query, that does what i want:
gewenste_begindatum = Date(sle_datumaankomst.text)
gewenste_vertrekdatum = Date(sle_datumvertrek.text)
Select "plaats"."plaatsid" INTO :teller
From "plaats"
WHERE "plaats"."plaatsid"
NOT IN (
Select "boeking"."plaatsid"
FROM "boeking"
WHERE (gewenste_begindatum > "boeking"."begindatum" AND :gewenste_begindatum < "boeking"."einddatum")
OR gewenste_vertrekdatum > "boeking"."begindatum" AND :gewenste_vertrekdatum < "boeking"."einddatum"))
OR gewenste_begindatum < "boeking"."begindatum" AND :gewenste_vertrekdatum > "boeking"."einddatum"));
this query works perfectly! it returns the result of a search.
the result of the query should be shown in a listbox which can be done by:
lb_listboxname.additem(string)
but i can't find out how the loop the result of the query.. if that is even possible ??
the 2 sle_name are singleLineEdits
is there is an other solution to this problem i'm happy to hear about them! mabye another control or so??
tnx in advance
Gijza
i'm new to powerbuilder (10) and i have a question.i have made the following query, that does what i want:
gewenste_begindatum = Date(sle_datumaankomst.text)
gewenste_vertrekdatum = Date(sle_datumvertrek.text)
Select "plaats"."plaatsid" INTO :teller
From "plaats"
WHERE "plaats"."plaatsid"
NOT IN (
Select "boeking"."plaatsid"
FROM "boeking"
WHERE (gewenste_begindatum > "boeking"."begindatum" AND :gewenste_begindatum < "boeking"."einddatum")
OR gewenste_vertrekdatum > "boeking"."begindatum" AND :gewenste_vertrekdatum < "boeking"."einddatum"))
OR gewenste_begindatum < "boeking"."begindatum" AND :gewenste_vertrekdatum > "boeking"."einddatum"));
this query works perfectly! it returns the result of a search.
the result of the query should be shown in a listbox which can be done by:
lb_listboxname.additem(string)
but i can't find out how the loop the result of the query.. if that is even possible ??
the 2 sle_name are singleLineEdits
is there is an other solution to this problem i'm happy to hear about them! mabye another control or so??
tnx in advance
Gijza