Hi all,
I have a DBGrid that is connected to a TSQLQuery with the following SQL:
UserFileLoad.SQL.Text := 'select Issue from Custom1';
So the DBGrid shows only the column 'Issue'. In the OnCellClick event of the DBGrid, I need to load the value from the corresponding 'ID' (primary key) column, based on which row of the table the user has clicked on. Is there an easy way to do this? I seem to be running into issues because the SQL query that populates the DBGrid does not load the ID column.
In your answer, please assume I am stupid, because I am.
Thanks!