Listview with dbutils

padvou

Active Member
Licensed User
Longtime User
Dear All,
i'm trying to execute this:
Dbutils.ExecuteListView(SQL1,"SELECT 'Product: ' || Materialcode || ' ' || materialdesc, 'Quantity: ' || SelQuantity || ' Price1: ' || whsprice || ' Price2: ' || rtlprice FROM ordersslave where masterid= '" & CurrentOrderID & "'",Null,0,LVDb,True)

How can I show the results to a listview in two rows so that the two columns returned from the above query can be each in one row?
Before adding concat to the query, results where shown, now nothing is shown...
Thank you in advance
 
Top