469,934 Members | 1,903 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

PARAMETERS FOR STORED PROCEDURES (UPDATE, APPEND)

A question concerning Access Project with SQL Server:

I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated or
inserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored procedures
that are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it using
Input Parameters property of forms (or I can?).

Thanks.

Zlatko
Nov 13 '05 #1
3 1964
"Zlatko" <zl**********@pliva.hr> wrote in message
news:cm**********@ls219.htnet.hr...
A question concerning Access Project with SQL Server:

I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated
or
inserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored
procedures
that are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it
using
Input Parameters property of forms (or I can?).


Call the parent procedure from your form or from code using ADO,
(preferable), and use sp_executesql within your stored procedure to run the
child procedures from the parent. Look up sp_executesql in BOL for more
info.
Nov 13 '05 #2
On Mon, 8 Nov 2004 11:08:50 +0100, "Zlatko" <zl**********@pliva.hr>
wrote:

I'm assuming you are using ADO. So create a command object, append
some parameter objects to it, and execute it.

-Tom.

A question concerning Access Project with SQL Server:

I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated or
inserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored procedures
that are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it using
Input Parameters property of forms (or I can?).

Thanks.

Zlatko


Nov 13 '05 #3
How to solve it without using ADO?

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:53********************************@4ax.com...
On Mon, 8 Nov 2004 11:08:50 +0100, "Zlatko" <zl**********@pliva.hr>
wrote:

I'm assuming you are using ADO. So create a command object, append
some parameter objects to it, and execute it.

-Tom.

A question concerning Access Project with SQL Server:

I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated orinserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored proceduresthat are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it usingInput Parameters property of forms (or I can?).

Thanks.

Zlatko

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Bari Allen | last post: by
3 posts views Thread by Zlatko Matić | last post: by
10 posts views Thread by Adis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.