>Hi all,
>
>What is the consensus out there (or the divergence? <g>) as regards
>using Stored Procedures vs having the code as part of one's
>program/form ?
>
>Thanks in advance.
>
>Michel Creppy.
I like using Stored Procedures for processes (such as calculating the unique key id for a table, etc...) that will be used uniformly in a DBC especially if you have multiple applications hitting or using the same DBC.
For me as a general guide, if it's universal for that DBC put it in the Stored Procedures. If it's application specific, keep it in the application. If you're using Classes and it's specific to the Class, put it in the Class.
Tom
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only