if ADOQuery2.Active then ADOQuery2.Close ; ADOQuery2.SQL.Text := 'SELECT SUM(Amount) as total_Amount FROM debit WHERE Category = '1st bill' and IDNumber='+QuotedStr(edStudentID.Text); nah ketika saya menuliskan ini di delphi kenapa error? padahal saya coba di SQL nya seperti ini bisa SELECT SUM(Amount) as total_Amount FROM debit WHERE Category = '1st bill' and IDNumber='A12345'; errornya 1. [Error] Unit1.pas(162): Missing operator or semicolon 2. [Error] Unit1.pas(162): Statement expected, but expression of type 'String' found tolong bantu saya..

ADOQuery2.SQL.Text := 'SELECT SUM(Amount) as total_Amount FROM debit WHERE Category = '+QuotedStr('1st bill')+' and IDNumber='+QuotedStr(edStudentID.Text);

SELECT SUM(Amount) as total_Amount FROM debit WHERE Category = ''1st bill'' and IDNumber='+QuotedStr(edStudentID.Text)

IDNumber='A12345'; tipe datanya ada yg salah klii..?klo idnumber nya integer..? yaa inttostr(id.text) bukan '+QuotedStr(edStudentID.Text); quotedstr buat tipe text.. trus.. klo sql.text mestinya pakai sql.text:=( ' select..........' ) ; mffin sy klo salah yha.. :) makasih

coba cek tanda kutipnya