Using Vues or Stored Procedures ?

  • Thread starter Thread starter tf85
  • Start date Start date
T

tf85

Hello,
With MS Access Project I use Views and Stores Procedures.
But With Borland Builder C++ V3.0, I can't use the SP, because I have an ADO
component without Stores Procedures component.
So, If I transform my Stores Procedures to Views, is it a good idea ?

Thank you
 
Only simple Stored Procedures can be easily convertied to views.

I'm not sure to understand why you cannot use SP with Borland C++ 3.0; as
using ADO should shield you from the limitation of this old version.

S. L.
 
Not a good idea at all if there are variables in your SPs, they won't work
anymore... A view is exactly as it sounds, a view of the data. A SP can
have input and output variables...

HTH,
Drew
 
I have the BCB3.0 Pro (without ADO object).
I use a freeware ADO object (aoADOdb), its SP part is buggy, the SPs don't
return any value.
So i search some thing else or use Views only
 
Back
Top