Access Stored Procs

Anything not covered by the Defects/Enhancement forums

Access Stored Procs

Postby CadyConnections on Mon Oct 04, 2004 4:33 pm

In the template that generates the stored procs for access. It appears to use the same syntax for LoadAll and LoadByPrimaryKey. Yet in the database explorer LoadAll appears under View not stored procs. How does access determine if it is a view or stored proc. Is it that views don't take any parameters?

Also since they show up as views why do they execute when I run the c# business entity?? Shouldn't I have to run the business view??

Thanks :!:
CadyConnections
Lurker
 
Posts: 7
Joined: Fri Sep 24, 2004 12:09 am

Postby mike.griffin on Mon Oct 04, 2004 4:56 pm

Yes, Access treats stored proc's that do not take any parameters as views or queries (I think). It's just how access shows them in their User Interface, just consider them as stored procedures.
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN


Return to Template Library General

Who is online

Users browsing this forum: No registered users and 1 guest

cron