Stored Procedures

[kcsilentbob]

I am trying to find a place on how to learn stored procedures. I am not even sure where to start or what program can be used to create them.

I have:

Crystal XI standard
MS Access 2000
MS VB 6.0

Can anyone point me in the right direction?

 

[Turkbear]

Hi,
Some ideas here:

http://www.devcity.net/Articles/18/msaccess_sp.aspx

and for CR usage:

http://technicalsupport.businessobj...sliceId=&dialogID=1270897&stateId=1 0 1272344

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kcsilentbob]

Do stored procedures do anything special that I couldn't do in Crystal?

 

[Turkbear]

Hi,
Probably..Processing data requests at the server rather than after records are returned to the reporting tool ( like Crystal) is usually more efficient - However, unless you are really good at creating them, doing it in Crystal will probably be a better choice..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

SPs in MS Access are an afterthought, started in Access 2000. In most databases they allow for temp tables, but not in Access.

I'd suggest that you use the query designer in Access for complex requirements, and expose the query to Crystal.

One common complaint for all SPs is the user experience when trying to use multiple value parameters, as most databases only support a single value to a parameter, so you pass a single value or a comma delimited string and parse it out.

Access queries are akin to Views, and since you can base Access Queries on other queries, you can perform very advanced functions.

-k