Delphi XE3 EDB 2.14 build 5

Hello

If I plonk an EDBStoredProc on a form, assign the name of the SP in the IDE, then call the following to open the SP, I get an 'Argument out of range' error.

   ESPDriver.Close;
   ESPDriver.Params[0].AsBoolean := False;
//    ESPDriver.ParamByName('OnlyActive').AsBoolean := False;
   try
    ESPDriver.ExecProc;
   except
    raise;
   end;

The error happens almost always the first time I call the EDBStoredProc. If I then rem the Params line and pass the ParamByName, it works. If I then rem out the ParamByName line and revert to Params - it works equally well!!

It appears that the Params list has zero members, though I am not sure that I can do anything about that.

To be fair, I sometimes copy the component from another form, as some of the fields are already populated, but I always re-assign the target SP before I do anything.

As with any mysterious error I am concerned that it will return to haunt me later. Any suggestions?

Regards

Peter

Peter


Add  ESPDriver.Prepare before the first time you try to use the proc.

Roy Lambert [Team Elevate]

Doh!

I had inspected the Params property in the IDE and noticed that in every case the correct name and index of each parameter was listed, so assumed that if it could see it in the IDE then it would see it in the app. Silly me.

Thanks Roy

Regards

Peter

Peter


Its caught me many times.

Roy Lambert [Team Elevate]