StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Parameter in stored procedure
Parameter in stored procedure
Post Reply
Like
1
Parameter in stored procedure
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Ian Johnston
Ian Johnston
posted 7 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 77,
Visits: 470
Thank You
Reply
Like
1
StrataFrame Team
S
StrataFrame Team
posted 7 Years Ago
ANSWER
Post Details
Share Post
S
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
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
AS
BEGIN
-- blah blah blah
END
Reply
Like
1
Ian Johnston
Ian Johnston
posted 7 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 77,
Visits: 470
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.
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search