Error Doing SQL Queries

Error Doing SQL Queries


After adding the SQL of GetAvailableRoom, some errors appeared, such as, "invalid SQL unknown NumberOfAdults parameter in GetAvailableRoom".

I noticed there are no parameters for the SQL, as shown below. Do I hae to add the parameters manually? Or can I drag and drop from the Booking entity's attributes in the Data perspective? Thanks!

You can do it both ways.

I guess drag and drop is from Data perspective. But (I don't know) how to drag and drop? Thanks!

If you don't know how to drag and drop add manually. Right button and add the parameters/entities.