I am getting an error in the red circle. Do you know what the cause is?

Hi Kusaka,

The sql query is not having the table to execute the query and its also not having the output structure to return the output of the query.

Regards,

Koushik

Hi,

You need to set the input parameters and output entities of the SQL. For output you need to select the entity Room since you are selecting it. For input parameters, when you refer something like @NumberOfAdults you are saying that there will be an input parameter with name NumberOfAdults.

Regards,

Marcelo

Marcelo Ferreira wrote:

Are the items specified in the red circled SQL properties correct?




Hi,

You need to set the input parameters and output entities of the SQL. For output you need to select the entity Room since you are selecting it. For input parameters, when you refer something like @NumberOfAdults you are saying that there will be an input parameter with name NumberOfAdults.

Regards,

Marcelo



Hi Kusaka,

Those are called SQL input parameters. On the bottom right you need to put the input values you want to pass to the SQL. For sure you don't want to send BookingId to all of them. Pass the correct values that you should have on the form of the screen.

Regards,

Marcelo