Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / November 2004

Tip: Looking for answers? Try searching our database.

PARAMETERS FOR STORED PROCEDURES (UPDATE, APPEND)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Zlatko - 08 Nov 2004 10:08 GMT
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
John Winterbottom - 08 Nov 2004 13:43 GMT
>A question concerning Access Project with SQL Server:
>
[quoted text clipped - 12 lines]
> 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.
Tom van Stiphout - 08 Nov 2004 13:47 GMT
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:
>
[quoted text clipped - 13 lines]
>
>Zlatko
Zlatko - 09 Nov 2004 07:10 GMT
How to solve it without using ADO?

> I'm assuming you are using ADO. So create a command object, append
> some parameter objects to it, and execute it.
[quoted text clipped - 18 lines]
> >
> >Zlatko
Chuck Grimsby - 09 Nov 2004 10:24 GMT
Use a Pass-Thru Query and just:
 EXEC sp_myStoredProceedure 'param1', 'param2'

>How to solve it without using ADO?
>
[quoted text clipped - 23 lines]
>> >
>> >Zlatko

Signature

    A Project Not Worth Doing At All Is Not Worth Doing Well.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.