Registriert seit: 17. Mai 2006
Ort: Leipzig
283 Beiträge
Delphi XE2 Professional
|
Re: SQL problem
7. Dez 2009, 14:50
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
Billy Gerwitz "Bei der Softwareentwicklung suchen wir nicht den richtigen Weg, sondern den am wenigsten falschen." - frei nach V. Hillmann
|