SHOW VAR will list ones that are being used, but don't know where to list of all. Tom Hart
________________________________ From: mjsmd <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, June 20, 2009 10:31:51 PM Subject: [RBASE-L] - RE: DB GRID--how do I get the value of the cell into a variable? Where can I read about other items similar to .RBTI_COL_NAME and .RBTI_COL_VALUE? I don't remember seeing these under the help menus. Michael Sinclair, MD www.epilution.com (\__/) (='.'=) (")_(") On Jun 20, 2009, at 10:54 PM, "John Docherty" <[email protected]> wrote: > 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 > >

