Using Vues or Stored Procedures ?

[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

 

[Sylvain Lafontaine]

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.

 

[Drew]

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

 

[tf85]

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