StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Parameter in stored procedure

Parameter in stored procedure

Ian Johnston — Mon, 27 Mar 2017 09:30:02 GMT

How do you define a parameter for a stored procedure in DDT, I have put @current DATE in the pre-create section but it gives a syntax error when I try to send it to the server.

RE: Parameter in stored procedure

Ian Johnston — Mon, 27 Mar 2017 09:30:02 GMT

Thank You

RE: Parameter in stored procedure

StrataFrame Team — Mon, 27 Mar 2017 08:58:42 GMT

The DDT will output "CREATE PROCEDURE " + [the procedure name] + [the procedure body].

So, you'll want to put the procedure body like this:

@startDate DATETIME,

@stopDate DATETIME,

@userPk INT

BEGIN

-- blah blah blah

END