Hello Sentient,

Yes you can learn on how to create and use flat tables from Demonstration 31:

http://www.datasprings.com/formdemos

You will catch on quickly from the first part of three parts of the demonstration.

If you have any questions please let me know.

Thanks,

Ryan

Thanks, That has the INSERT details but Im looking for a Stored Procedure that uses variables populated by tokens
So the @Something = $(Something)

How can I push the shortfield to the Stored Procedure? It says that we should be using this to prevent Injection.

Thanks

Hello Sentient,

To push the $(token) over to the stored procedure be sure to use tick marks since it will most likely be a string value. Numbers, letter, or symbols can be considered strings.

So the format/syntax would look like this:

exec storedProcedureName '$(token1)', '$(token2)'

Now here's what your stored procedure could look like

CREATE PROCEDURE storedProcedureName(
@tokenOne nvarchar(200) NOT NULL,
@tokenTwo nvarchar(200) NOT NULL
)

AS

BEGIN

INSERT INTO yourTable WHERE yourColumn1 = @tokenOne AND yourColumn2 = @tokenTwo

END

If you have any questions please let me know.

Thanks,

Ryan

Perfect answer - sorry the feedback was late