🚀 go-pugleaf

Hey Irongizon...
I got a couple of  questions and a suggestion or two.
Q1. Why are you using a stored procedure with Access 2000?
Q2.  Why are you using the Open() method?

Here are my suggestions...
S1. Since as fas as I know Access2000 doesn't have store procedure support
as a feature you shouldn't use a stored procedure component.  Try using
ADOCommand.  It will allow you to place your SQL statement in it.  You can
specify params in the statement by :param1, :param2, etc.

S2.  If you still want to use the stored procedure or choose to go with the
ADOCommand,
you should use the ExecProc() method for stored procedures and Execute()
method for the ADOCommand.  This assumes that your are not returning a
dataset, from the SQL Statement;

For Ex:
UPDATE (tbl_Employee)
SET employee_type = 5
WHERE employee_ID = 4501;

Ex#2:
UPDATE (tbl_Employee)
SET employee_type = :NewEmpType
WHERE employee_ID = :EmpID;

The second example uses parameters.

By the way this statement is correct...
      MyStoredProc->Parameters->ParamByName("param1")->Value = i;

Good luck and write back if it doesn't work/help.


"Irongizon" <grangizon@lycos.es> wrote in message news:3bd6ab8c$1_1@dnews...
> Hi.
>
> I'm using ADO components in a  C++ Builder 5 application. I'm using a
> MSAccess 2000 database in which I have some parametered queries. With an
> TADOStoreProc I try to use one of this parametered query, in this way:
>
> for (i=0; i<CRCIDBLK_MAXNUMERO; i++){
>
>       MyStoredProc->Close();
>       MyStoredProc->Parameters->ParamByName("param1")->Value = i;
>       MyStoredProc->Open();
>
>       // Process of Data
>       .....
> }
>
> What happend is that the parameter value is not updated for each call,
> although I close the StoreProc and it always returns the same result. It
> always takes the value that is given in the first time (i=0).
> I would be grateful whether somebody Knows how to do the value of the
param
> was updated.
>
> Regards and Thanks in advanced.
>
> Raul.
>
>