I am setting up an integration and label file which does the following: The integration is a database integration which will pass SQL Server values form a database record to the label with the print action.  The values passed in to the label will need to be used as parameters for the stored procedure call.  I set those up as query prompts but I read this: 
Depending on the type of database in use, you may also need to check the “Use Client Cursor” checkbox. This checkbox is located on the Options tab in Database Connection Setup for all databases that support a local client cursor. In your case, please enable it.

I am using BT 2022 and connection to SQL Server but I see no Options tab in the Database Connection Setup to find that checkbox.  In my case, it immediately prompts for the values, then errors out with a mangled SQL statement without supplying any defaults at all.