Ergebnis der Suchanfrage

• Forum: Programmieren allgemein

  AW: SQL Query in object Inspector

   
    by question, 9. Feb 2014
  Thanks for your reply
  I have another question, for example i can insert data into two different using one ADOQuery but when i would like to update two table using one ADOQuery then i got an error
  "Aplication uses a value of the wrong type for the current operation"
  ADOQuery3.DisableControls;
  ADOQuery3.EnableControls;
  ADOQuery3.Parameters.Value:= Edit1.Text;
  ADOQuery3.Parameters.Value:=2;...
• Forum: Programmieren allgemein

  SQL Query in object Inspector

   
    by question, 8. Feb 2014
  Hi,
  I am writing a simple query in delphi which is working fine
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('SELECT bezeichnung FROM artikel where artnr=:ID');
  ADOQuery1.Parameters.ParamByName('ID').Value:=2;
  ADOQuery1.Open;
  but if i write the same code ADOQuery1 in object Inspector and write the following code
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;