Must declare the scalar variable


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

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

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

Hi @MiGui !

Happy to help here!

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

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?