• Registered: 2014-10-10
  • Posts: 156

Topic: Display grid contain in to "Text Box"

Sir,

In TrackingDB, I want to copy 'Student Name' and 'Mobile No' to do further query.

For that, I return a script in grid cell check to

But, for some row it is display contain and for some row not display contain.

Ex- for first 3 row it is not display contain and 4,5,6,... row its display

and at bottom rows it is not  display contain,

Please check

Or any other way?

Please see attach file and photo.

https://www.dropbox.com/s/f5mak4jt73jp6 … P.rar?dl=0

Regards
Nitin Ingale

Post's attachments

Attachment icon Not Displaying.gif 202.13 kb, 190 downloads since 2017-10-14 

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

Re: Display grid contain in to "Text Box"

Hello.

Wrong script

procedure TrackingDashBoard_TableGrid1_OnCellClick (Sender: string; ACol, ARow: Integer);
begin
     TrackingDashBoard.Edit3.Text := SqlExecute('Select StudentName From StudentDB Where Id = ' + TrackingDashBoard.TableGrid1.sqlvalue);
     TrackingDashBoard.Edit4.Text := SqlExecute('Select MB1 From StudentDB Where Id = ' + TrackingDashBoard.TableGrid1.sqlvalue);
end;

TrackingDashBoard.TableGrid1.sqlvalue
return ID of "DeliverablesDB" table, not "StudentDB"



try this

procedure TrackingDashBoard_TableGrid1_OnCellClick (Sender: string; ACol, ARow: Integer);
begin
     TrackingDashBoard.Edit3.Text := TrackingDashBoard.TableGrid1.Cells[1,TrackingDashBoard.TableGrid1.SelectedRow];
     TrackingDashBoard.Edit4.Text := TrackingDashBoard.TableGrid1.Cells[2,TrackingDashBoard.TableGrid1.SelectedRow]
end;
Dmitry.
  • Registered: 2014-10-10
  • Posts: 156

Re: Display grid contain in to "Text Box"

Thank you very much Sir.