Update and Return from a stored procedure

B

bharat

Hi folks,
I have a stored procedure that will accept
parameters and based on some criteria it updates the
tables. I want to get the row that is updated and access
the records of that row in a single query from vc++.
How can I do that?
Any help is appretiated.
Thanks
Bharat
 
M

[MVP] S. Clark

**This query section is for Microsoft Access, so in the future you may want
to visit the SQL Server newsgroups.**

You can build all of the logic into the stored proc.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access ADP Form and Stored Procedure as RecordSource 0
changing parameters on a stored procedure 5
Consolidation Table from Different Excel Tabs with Different Format 1
Append Crosstab Query to Existing Table 0
Access pass-through query to Oracle 10g stored procedure - results 1
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How To Call A SQL Stored Procedure From Access 1

Top