• Registered: 2019-09-04
  • Posts: 39

Topic: Select column in tablegrid search results

Helllo Dmitry, Sibprogsistem, Derek and all MVD lovers

How do I query database to select column in tablegrid search results

SELECT GROUP_CONCAT(DISTINCT contact)FROM students WHERE student.id=' + bulksms.TableGrid1.sqlValue

code not working

I need an urgent help

Thank you in advance

  • Registered: 2019-09-04
  • Posts: 39

Re: Select column in tablegrid search results

hotice546 wrote:

Helllo Dmitry, Sibprogsistem, Derek and all MVD lovers

How do I query database to select column in tablegrid search results

SELECT GROUP_CONCAT(DISTINCT contact)FROM students WHERE student.id=' + bulksms.TableGrid1.sqlValue

code not working

I need an urgent help

Thank you in advance

Any help from MVD lovers?

  • Registered: 2018-07-19
  • Posts: 260

Re: Select column in tablegrid search results

Can you elaborate a little bit on the problem?

@thezimguy

thezimguy's Website

  • Registered: 2019-09-04
  • Posts: 39

Re: Select column in tablegrid search results

thezimguy wrote:

Can you elaborate a little bit on the problem?

Thank you very much in the first place for showing much concern

I want to select a particular column for a seach result.

Post's attachments

Attachment icon sms.JPG 51.26 kb, 143 downloads since 2019-10-19 

5 Reply by thezimguy (edited by thezimguy 2019-10-19 19:01:01)

  • Registered: 2018-07-19
  • Posts: 260

Re: Select column in tablegrid search results

procedure bulksms_Button1_OnClick (Sender:TObject; Cancel:Boolean);
var
    Results: TDataSet;
    contacts: String;
begin
  SQLQuery('SELECT GROUP_CONCAT(DISTINCT contact) AS contacts '+
  'FROM students '+
  'WHERE '+
  'id_form= "' + bulksms.ComboBox1.sqlValue + '" AND '+
  'id_class= "' + bulksms.ComboBox2.sqlValue + '" AND '+
  'id_course= "' + bulksms.ComboBox3.sqlValue + '"'+
  ';', Results);

  contacts := Results.FieldByName('contacts').AsString;
  ShowMessage(contacts);
end;

Let me know of any challenge

@thezimguy

thezimguy's Website

  • Registered: 2019-09-04
  • Posts: 39

Re: Select column in tablegrid search results

thezimguy wrote:
procedure bulksms_Button1_OnClick (Sender:TObject; Cancel:Boolean);
var
    Results: TDataSet;
    contacts: String;
begin
  SQLQuery('SELECT GROUP_CONCAT(DISTINCT contact) AS contacts '+
  'FROM students '+
  'WHERE '+
  'id_form= "' + bulksms.ComboBox1.sqlValue + '" AND '+
  'id_class= "' + bulksms.ComboBox2.sqlValue + '" AND '+
  'id_course= "' + bulksms.ComboBox3.sqlValue + '"'+
  ';', Results);

  contacts := Results.FieldByName('contacts').AsString;
  ShowMessage(contacts);
end;

Let me know of any challenge

Thank you so much. I'm really grateful