setting Stored Procedure Prepared
Posted on 2012-09-15
I have recently discovered som errors in my coding concerning the use of the TADOStoredProc component in Borland C++ Builder.
I have in some instances ommitted to do an ADOStoredProc1->Prepared = false before setting the parameters and then doing anADOStoredproc->Pepared = true, prior to executing the stored procedure. This results in un-reliable execution of the stored procedure and I can simply correct this by empoying an ADOStoredProc-.Prepared = false statement.
My question is as follows:
Do I need to set ADOStoredProc->Prepared to false even though I have just set ADOStoredProc->Active to false ?