B4J Question SQL Query - add dummy rows if number of rows is under value x

It is not easier to do it with the result set size versus the desired number of rows?

SELECT *
FROM (
select id, room
FROM rooms
union all
Select 0 id, 'empty room' room
union all
Select 0 id, 'empty room' room
union all
Select 0 id, 'empty room' room
union all
Select 0 id, 'empty room' room
union all
Select 0 id, 'empty room' room
) LIMIT 5

if there are less than 5 it, on of the dummies will appear

Thanks. I edited the first post a little bit. The defined number is a variable and can change.
It can be 5, 10 or 20 etc.

I found something which goes into the direction, but the number is fixed:

It’s easier to use B4X to add the dummy with loop after getting the query results.

Sorry, isn't it an abuse as programmers to do something like that? Is it not easier to manipulate the size of the result and do what is necessary to present what you want?

Hello,
thank you for your answers. I know that the task is a little bit tricky. I will explain why I need it this way and explain the background:
The used IDE is not B4J but VS .net. The reason why I am asking the question in this forum is because I got very good feedback
and solutions from the community in the past. If it is not wanted please move the thread to a appropiate theme or delete it. I would also pay
for the solution so maybe the business forum might fit ;-)

I have a control which generates a ganttchart from a database. I do not have the sourcecode of the control. The control has several advantages,
that is the reason why I would like to use this one. It has one disadvantage: It streches the height of the row depending of the quantity
of the entries. The following illustration is done with openoffice, but the principles shout be clear

Picture 1,2,3 current behavior, Picture 4 is the wanted behaviour.

I have no chance to loop through the resultset. I can only insert an sql query due to internal addressing the control.

Kind regards
h725

in that case the proposals submitted are valid.
Try them.

you could mix my advice with a loop

you could pass the numer of rows you need and inside the dummy row

Ok Thank you very much. I will try.