I have a sum query on a integer field in delphi. It does not work. It tells me invalid field. If i change the TYPE from INTEGER to DOUBLE the sum query works. Any ideas. The sum query (with the integer field) works in MYSQL if i run it there.But if i run it through DELPHI it does not work.