Hi All

I need to transfer selected values from a DBGrid to a DBMemo

Given the following code

     procedure TfrmCourses.DBGrid2DblClick(Sender: TObject);
     begin
        DBMemo3.Lines.Add(DBGrid2.???);
     end;

I would like the row values in the Grid transfered to the memo when a user double clicks the specific row. Idealy, I would like to transfer only cells from specific columns.

I can't seem how to proglimatically capture the data I need.

Any help would be much appriciated. I am still a newbie to Lazarus but my program is beginning to take shape.

Thanks in advance

Chris

DBGrid shows values from a DataSet, so use DataSet instead: Lines.Add(DataSet.FieldByName('MyField').AsString)

Best regards,
Paul Ishenin.

Thanks but

DBMemo3.Lines.Add(datGrid.FieldByName('crs_courseName').AsString)

returns

u_courses.pas(124,30) Error: identifier idents no member "FieldByName"

where "datGrid" is the name of my TDatasourse and "crs_courseName" is a column in my db

Do not use TDatasource use TDataset (TSQL Query SQLDB component or TSQL Query Zeoslib component).

Ex:
DBMemo3.Lines.Add(SQLQuery.FieldByName('crs_courseName').AsString)

Cheers,
Diwa

Thanks - that did the trick