Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mikhal, 7. Dez 2009
  ABSQuery1.SQL.Text := 'UPDATE Sensors SET Field="' +sField+'"' +','+'Value="'+sValue+'"'+',' +','+'Min="'+sMin+'"'+',' +','+'Max="'+sMax+'"'+' WHERE hwm_id = :HWM_ID and sensor_class = :Sensor_Class and sensor_id = :Sensor_ID';
  AbsQuery1.ParamByName('HWM_ID').AsInteger := ...
  ...
  
  
  Mikhal
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mikhal, 7. Dez 2009
  Yes, it was my mistake. You must use ABSQuery1.ExecSQL in the last line before 'end;' of every For-loop.
  
  Your attempt to update your table will be destroyed with the line 'ABSQuery1.SQL.Clear;'. Put the line first, then the statement.
  
  Mikhal
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mikhal, 7. Dez 2009
  Look at this:
  
  
  
  ABSQuery1.SQL.Clear;
  ABSQuery1.SQL.Add('Insert into Sensors (Field,HWM_ID,Sensor_ID,Sensor_Class,Monitor_Name) values ( :Field, :hwm_id, :sensor_id,:sensor_class,:Monitor_Name );');
  
  // Probably here prepare the Query!
  // ABSQuery1.Prepared := True;