Mike, Go to Help, Search, RBTI System Variables Used in Forms
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of mjsmd Sent: Sunday, 21 June 2009 3:32 p.m. To: RBASE-L Mailing List 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 > > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
