Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mkinzler, 7. Dez 2009
  Try parameters
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mkinzler, 7. Dez 2009
  Conversion is not needed
  ABSQuery1.ParamByName('HWM_ID').Value := hwm_index);
  ABSQuery1.ParamByName('Sensor_Class').Value := SENSOR_CLASS_VOLTAGE;
  ABSQuery1.ParamByName('Sensor_ID').Value := sensor_index;
  
  You could use here parameters too:
  
  UPDATE Sensors SET Field = :field ,value = :Value, Min = :min, Max = :max WHERE HWM_ID = :HWM_ID and Sensor_Class = :Sensor_Class and Sensor_ID =...
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mkinzler, 7. Dez 2009
  Is an error shown or just nothing happens?
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mkinzler, 7. Dez 2009
  Ist just oen reason for parameters. But the main reasons are type-conversion, type formats (e.g. date values) and the performance boost of using prepared statements for mass import/updates etc.
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by mkinzler, 7. Dez 2009
  And why? Just makes statement less readable
  
  No this are Parameters. Type is automatically set by dbms.