J
Jim Heavey
If I trying to write code which is not dependant on which database I am
using. I have developed the code for SQL Server and it is working just
fine, and now I have created the same data in MS Access. I am currently
running all stored procedures. I know that I have run "procedures" in
access, but I do not quite remember how to set this up. When I build the
query in Access, how do I identify a parameter value is required and where?
Do I create "command parameters" for these parameters in C#?
If I have written my application code taking advantage of SQL's ability to
pass multiple answer sets, will I be able to get Access to pass multiple
answer sets as well, or have I made my code database specific?
Does Access have a "@RETURN_CODE"? How do I check the success of an Access
query?
Thanks in advance for your assistance!!!!!!!!
using. I have developed the code for SQL Server and it is working just
fine, and now I have created the same data in MS Access. I am currently
running all stored procedures. I know that I have run "procedures" in
access, but I do not quite remember how to set this up. When I build the
query in Access, how do I identify a parameter value is required and where?
Do I create "command parameters" for these parameters in C#?
If I have written my application code taking advantage of SQL's ability to
pass multiple answer sets, will I be able to get Access to pass multiple
answer sets as well, or have I made my code database specific?
Does Access have a "@RETURN_CODE"? How do I check the success of an Access
query?
Thanks in advance for your assistance!!!!!!!!