trouble with the ADO-TStoredProcedure component
From: Pascal Schmidt-Volkmar (nospam_at_schmidt-volkmar.com)
Date: 12/28/03
- Next message: Brian Bushay TeamB: "Re: TBetterADODataSet - Row handle referred to a deleted row or a row marked for deletion"
- Previous message: sara cox: "Re: How do I add a record to an MS Acess DB using Delphi and ADO? Newbie"
- Next in thread: Brian Bushay TeamB: "Re: trouble with the ADO-TStoredProcedure component"
- Reply: Brian Bushay TeamB: "Re: trouble with the ADO-TStoredProcedure component"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Brian Bushay TeamB: "Re: TBetterADODataSet - Row handle referred to a deleted row or a row marked for deletion"
- Previous message: sara cox: "Re: How do I add a record to an MS Acess DB using Delphi and ADO? Newbie"
- Next in thread: Brian Bushay TeamB: "Re: trouble with the ADO-TStoredProcedure component"
- Reply: Brian Bushay TeamB: "Re: trouble with the ADO-TStoredProcedure component"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]