trouble with the ADO-TStoredProcedure component

From: Pascal Schmidt-Volkmar (nospam_at_schmidt-volkmar.com)
Date: 12/28/03


Date: Sun, 28 Dec 2003 18:22:47 +0100

Hi there,

I am using the stored procedure component of the ADO section in Delphi 6.
When compiling my application with F9, do get the error, that 'clear'
is an undefined identifier.

These two lines throw the error:

procedure TfFaktAus.bAusAddClick(Sender: TObject);
var i : integer;
begin
 if cbFaktoren.ItemIndex<=0 then exit;
 with fDatenmodul do
  begin
   spUpdFakAus.parameters.refresh;
   spUpdFakAus.parameters.parambyname('@UMFRAGETYP').value:=sUmfName;

spUpdFakAus.Parameters.ParamByName('@AUSSAGE').Value:=lbAussagen.Items.Strin
gs[AktPos(lbAussagen)];
   spUpdFakAus.parameters.parambyname('@FAKTOR').clear; //here
   spUpdFakAus.parameters.parambyname('@PARAM').clear; //and here
   spUpdFakAus.execproc;
   lbAussagen.DeleteSelected;
   cbFaktorenChange(self);
  end; //with fDatenmodul
end;

I need to set the value to null as the value is connected with another table
via primary key. Setting a real value would mean that I do set a
relationship. But in my case I do need to delete this relationship. And so I
need to set the value to null, don't I?? But how..... Please help!!!

Thanks,

Pascal