SQL Database Connector with SQL Server - how to set parameters

Need help Database
1

New user here, trying to use Bubble as a UI for SQL Server data. Can’t figure out how to set the parameters on a stored procedure call. I want to have input boxes where the user sets a value for each parameter to the stored procedure, a button to refresh the data (call the stored proc), and a nice grid to display it (currently trying out the “Excel-like Handson Table”, which is nice).

I can get the data to display in the grid, but am stuck on how to set the parameters. Here are pictures of what I have so far. There is an input box called “Enter min total”.

snip1
snip11541×1364 93.3 KB

snip2
snip22917×1722 175 KB

Thanks in advance for your help!

2

try …

exec getPositions @minTotal

Assuming you have one argument to the procedure.

3

Well that was simple. Thanks a million!!!

4

I found using ‘?’ helped me

INSERT INTO example VALUES (?, ?, ?, ?)

$1 Name1
$2 Name2
$3 Name3
$4 Name4