Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 8. Dez 2009
  Fine. So what was the problem? I'm curious :-)
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Sorry i can't (and don't want to) install stuff, just to check your DB for you.
  You can proceed as follows:
  1.) Debug and check your parameters (:HWM_ID,...)
  2.) Check the entries in your DB. If there is no way to access the DB from outside of Delphi (i wasn't able to find any tool) just make a query with 'SELECT * FROM...' and check the recordset.
  3.) Compare the content of your DB with the...
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Sorry, but I don't know Absolute DB and how to use it. Can't you just lookup if your DB contains entries which match the parameters? Maybe you have something like a management tool for this kind of DB?
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Ok then i would guess its a database issue. What are the values of the parameters (:HWM_ID,...)? Are there database entries which match these? Because no match with "WHERE" - no update ;-)
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Do you still get these empty strings? Looks like the Values (,,) are empty or Format can`t convert them?!
  Maybe the parameter '%.3f' breaks the function (doen't know, never worked with Format)?
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Does the code compile? Do you get any error messages or arent there just any updated records?
  
  If it runs and there are just no records updated then set breakpoints and step through your code. Maybe one of the functions (CPUIDSDK_GetNumberOfSensors or CPUIDSDK_GetSensorInfos) returns a wrong value?
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Oh :oops: my fault. Just overlooked the whole parameter thing... Then move on Mr ;-) I don't know, how to address the parameters here.
  
  Ok, brackets arent necessary. Just a habit of me oO
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  What are :Sensor_Class, :HWM_ID, :Sensor_ID? Are these Delphi-Variables? Then you must quote and add them (if they are strings! otherwise you must convert them to string!)
  '...WHERE (HWM_ID = '+:HWM_ID+') and (Sensor_Class = '+:Sensor_Class+') and (Sensor_ID ='+ :Sensor_ID+')';
  
  And put brackets () around every logical statement!
  
  edit: rubbish
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Maybe you should cut out some + and some quotationmarks...
• Forum: Datenbanken

  Re: SQL problem

    Delphi
    by ToFaceTeKilla, 7. Dez 2009
  Dont know ABSSql but shouldn´t he use mikhals solution + ABSQuery1.ExecSQL;
  in EVERY for-loop (like he added in his 1st post) and not at the end?