Define that column in the variable drop down. Tom Hart
________________________________ From: Michael J. Sinclair <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, June 4, 2012 12:04:26 PM Subject: [RBASE-L] - Re: How to assign unique values to a column within a form Hi Bill, I don't think GUID is available in Rbase 9.5 (32), only Rbase 9.5 (64). I can live with the Random number generator picking numbers between 0 and 999999999. What I really need help with is how to make the EEP work with all rows including the last row. I think what I am looking for is something like ON EXIT ROW EEP, but I don't think that is an option anymore. Which EEP (Scrolling Region EEP vs DBedit field EEP) would be the correct place to put the EEP? Mike --- On Mon, 6/4/12, Bill Downall <[email protected]> wrote: >From: Bill Downall <[email protected]> >Subject: [RBASE-L] - Re: How to assign unique values to a column within a form >To: "RBASE-L Mailing List" <[email protected]> >Date: Monday, June 4, 2012, 11:33 AM > > >Mike, > > >If you are using 9.5, you should use GUID for this. See the 9.5 help. > > >Bill > > >On Mon, Jun 4, 2012 at 11:25 AM, Michael J. Sinclair <[email protected]> >wrote: > >Hi All, >>In Rbase 9.5 32, I have a form with a scrolling region. >>I would like to assign a unique value to column such that each new row has a >>unique random value. >>For other columns, I would like to have all the new rows have the same value >>such as today's date. >>I know I can do this easily in the add variable / expression builder area, >>but >>somebody said that is not a great way to do it because it can slow down the >>form >>since each expression is recalculated evertime a field is exited. >> >>When I try to add rows, I tried using an ON EXIT EEP from a field to update >>the >>column with a unique flag, like this.... >> >>SET VAR vrand = (RANDOM(999999999)) >>UPDATE tablename SET column name = .vrand WHERE uniqueflag IS NULL >>(I know I have 1 chance in 999999999 that the value won't be unique, I can >>live >>with that) >> >>That seems to work for every row except the last row I add. The last row does >>not get any value. >> >>What is the right way to give each new row a unique column value within a >>scrolling region? I think my problem might that I am choosing the wrong type >>off >>EEP. Is there an ON EXIT ROW EEP? >> >>Mike >
