Below data is in one column value of a table row (Oracle/remote server) and I am trying to display it in ListBox (Windows GUI). It works.
Errors in file /home/oracle/app/oracle/diag/rdbms/linuxtgt/linuxtgt/trace/linuxtgt_j000_40666.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_12600"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47207
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: at "SYS.DBMS_STATS", line 47197
However, I just see the first line (1/8) in the ListBox even though when I copy the cell and paste it in other editor, I can see 8 lines all.
Is the data in your “code” block a single value ?
You don’t tell us how you write the data into the listbox, neither what’s your use case.
I guess the data has an EndOfLine at the end of each line.
The listbox doesn’t adapt its row height to the content, so you’ll have to handle that differently.
Row height is at listbox level and apply to all rows.
You probably have end fo line markers that the list box interprets as the end of the cell data. perhaps you could try to remove those in the data before you add the row in the listbox.
Yes, absolutely there is a EndOfLine at the end of each line.
Tried to remove it and expected the concatenated one line with below code but it doesn’t work.
I don’t expect ListBox row to display multiple lines.
I am just thinking that I should merge all lines of my data having EndOfLine and keep the one row of ListBox.
Another option would be to use a hierarchical listbox, split your data in an array, show the first array element in the listbox as a folder and display the next elements when expanding the folder row.
I decided to use another Textarea at the bottom of the screen and the rest lines are displayed when the cell (listbox) is clicked.
It is better than concatenate all lines and display it a cell I guess.