You can concat several fields as value in the sql statement, like:
sqlCmd = ('+
select +
cunum as key, +
char(cunum) concat cuname as value +
from customer +
where lower(cuname) like lower(''%:query%'') +
');
But it will not look nice, because there is no styling. The best looking result will be creating a new javascript class, just like DDSEARCH and DDSQL, but with several columns, and styled using css. I can help you with this.
Re: Drop down lists with multiple columns
You can concat several fields as value in the sql statement, like:
sqlCmd = ('+ select + cunum as key, + char(cunum) concat cuname as value + from customer + where lower(cuname) like lower(''%:query%'') + ');But it will not look nice, because there is no styling. The best looking result will be creating a new javascript class, just like DDSEARCH and DDSQL, but with several columns, and styled using css. I can help you with this.