Must declare the scalar variable

App Building
,
1

Hi

getting back into retool after a few months to build new apps. Using the form module. I have created a table within MSSQL with the following datatypes

image
image793×102 2.78 KB

Form created then off the back of this. When it comes then to try and insert from a select i get the following error

image
image1586×620 90.4 KB

If i remove that select mapping it works fine for the first two fields. Any ideas?

2

Hi @MiGui !

Happy to help here!

SQL queries have a query property that is not accessible in GUI mode\

2242×1438 372 KB

2836×1532 501 KB

Can you screenshot the network tab when you're running this query? It will show the params that hold these inputs.

In addition, what are the column types used in the form generator resource?