• Registered: 2015-04-24
  • Posts: 85

Topic: groups

i know i ask many question just new in this kind of software and databases and im thankfull for you quick support
just wanna know is possible make groups and from TableGrid select users i mean multi select of users that i wannt move them to other group with right click and if not possible with right click in tablegrid how is possible the most important that can transfer user to the group i want as bluk
Thanks in advance

  • Registered: 2014-02-14
  • Posts: 10,294

Re: groups

Please, attach your project (zip file without dll and exe), I'll try do it in your project.

Dmitry.

3 Reply by abouyahya527911 (edited by abouyahya527911 2015-06-10 08:44:37)

  • Registered: 2015-04-24
  • Posts: 85

Re: groups

here in basic example for what i mean

Post's attachments

Attachment icon test.rar 3.24 kb, 494 downloads since 2015-06-10 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: groups

Done.

Post's attachments

Attachment icon test_fixed.zip 5.08 kb, 491 downloads since 2015-06-10 

Dmitry.
  • Registered: 2015-04-24
  • Posts: 85

Re: groups

yep done thank you i was wanted if there way to do it like this but instead button  i Select users and click right click in tablegrid and move them

  • Registered: 2014-02-14
  • Posts: 10,294

Re: groups

Here you can find, how to add own menu in TableGrid
http://myvisualdatabase.com/forum/viewtopic.php?id=1439

Dmitry.
  • Registered: 2015-04-24
  • Posts: 85

Re: groups

yes i sort this but just want litle help how use script to add 

procedure Form1_Button5_OnClick (Sender: string; var Cancel: boolean);
var
   i,c: integer;
   iColumn: integer;
begin
     iColumn := Form1.TableGrid1.Columns.Count-1; // in last column stored id of record (last column hided)

     c := Form1.TableGrid1.RowCount - 1; // count of records in TableGrid
     for i :=0 to c do
         if Form1.TableGrid1.Selected[i] then // if record selected
            SQLExecute('UPDATE testdata SET id_group = ' + Form1.ComboBox1.sqlValue +' WHERE id='+IntToStr(Form1.TableGrid1.dbIndexToID(i)) ); // SQL query for selected record

     Form1.TableGrid1.dbUpdate;
end;

in Menu i mean the fuction thanks

  • Registered: 2014-02-14
  • Posts: 10,294

Re: groups

Done, please download project

Post's attachments

Attachment icon test_fixed2.zip 5.98 kb, 507 downloads since 2015-06-11 

Dmitry.
  • Registered: 2015-04-24
  • Posts: 85

Re: groups

Thanks for your good support