• From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Topic: SQL Error

Hello Friends.. i am using this quey in Report Designer but not working.. please correct query  ,,

Memo10.Text := SQLExecute('Select sum((a.CAmount) - (a.PAmount)) from Credit a,CVeh b,CCompany c where b.id = a.id_CVeh and c.id = a.id_CCompany and b.id = <ComboBox2> and c.id = <ComboBox1>');

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: SQL Error

need help...

  • Registered: 2014-06-25
  • Posts: 863

Re: SQL Error

A little search on this forum ( up right of this very page... 'Search' ....)

And I would try this:

Memo10.Text := SQLExecute('Select sum((a.CAmount) - (a.PAmount)) from Credit a,CVeh b,CCompany c where b.id = a.id_CVeh and c.id = a.id_CCompany and b.id = {ComboBox2} and c.id = {ComboBox1}');


Source: http://myvisualdatabase.com/forum/view … 6517#p6517