I don't really understand what you're doing here. Why don't you get all your data just with one query like this:
_delimiter = char(9) //the delimiter you use for column parsing ov the VL
; query = “SELECT DISTINCT
a.MusteriIsmi AS COLUMN1,
(SELECT b.Porsiyon FROM vl_UPLITEMS b WHERE b.PlanTarihi = ? and b.\"_idOgun\" = ? and b.\"_idYMK\" = ? and b.MusteriIsmi = a.Musterilsim) AS COLUMN2
FROM vl_UPLITEMS a WHERE a.PlanTarihi = ? and a.\"_idOgun\" = ?"
; result = ExecuteSQL( query ; _delimiter ; "" ; UPL::PlanTarihi; UPL::_idOgun; 3148; UPL::PlanTarihi; UPL::_idOgun)
i couldn't accomplish that.
$$COLUMN1 and $$COLUMN2 are using in fields sperately on layout.
Have a look at the VL-parsing in this file. There are two custom functions used, to populate the fields in the VL from one $$variable, you can then place the fields wherever you like:
corresponding article here:
Many thanks Otmar. Thats just what i need to do.
Have a nice day.