Tag: delphi

use sql case statement in a adoquery of delphi

so i want to calculate a sum of a field using adoquery and case statement in delphi ; the code i use is this : but i gest an error message : syntax error operator absent in the expression case when month(DATE_PAI)=1 then sum(MT) else 0 end can any one help me please Answer Try to do : (group SELECT

Can’t find a field in a table

delphi ms-access sql

I have a table containing the field ‘cost’, when I try to extract its value from the table I get an error saying the field was not found. function TSQLs.Get(value,room,hotel: string): string; begin …

Delphi 7 Syntax error (comma) in ADO query

delphi sql tadoquery

I’m trying to create a record in a database using a SQL query in Delphi 7. I’m using an ADO Query and I’ve tried both with and without parameters, but to no avail. The error occurs between ShowMessage 1 and 2. The commented out part was the one way I tried doing this, and it gave this error: Syntax error