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
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