I can confirm that GUID data type is available only on RBase v9.5 (64 bit).
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 >________________________________ > From: "[email protected]" <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Monday, June 4, 2012 12:33 PM >Subject: [RBASE-L] - Re: How to assign unique values to a column within aform > >You could assign an on insert trigger on the table. The logic in the trigger >could guarantee each row has a value that makes it unique based on random >numbers. > >Ken > >On Mon 06/04/12, at 1:03, Michael J. Sinclair <[email protected]> wrote: > > > >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 wrote: >From: Bill Downall Subject: [RBASE-L] - Re: How to assign unique values to a >column within a formTo: "RBASE-L Mailing List" 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 > > > > >
