Mike, The method I use with a DBGrid is to have an autonum column in the table, which uniquely identifies each row (SEQNO). I have a variable in the form which is equal to this value (vseqno).
I then have an ONClick EEP which determines which column was clicked on, as follows:- SET VAR vcol TEXT=.RBTI_FORM_COLNAME Then, based on which column the user was in, (e.g. if you want to retrieve the value in the no column) I have a command, as follows:- SET VAR vnox REAL=no IN sched WHERE seqno=.vseqno This may not be the best way to do this, but it may get you started. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Sunday, 21 June 2009 2:11 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - DB GRID--how do I get the value of the cell into a variable? Hi All, I hope this is simple and I just can't find it. I am using the OnKeyPress code that was generously shared to rapidly find rows in a table. One I have narrowed down the rows to just a few, I would like to click on a cell and get the value from that cell to go into a variable to be displayed elsewhere on the form. I think I have to use EEP associated with clicking on the cell. What do I need to do to capture that value? I think I need the GETPROPERTY to extract the value and the PROPERTY command to send the value to some other Variable Edit on the form, but I can't find the syntax. Any help or sample code would be very much appreciated. Thanks! Mike Sinclair
