Cool! I'll look forward to testing it with the next build! Text works just fine for what we need so I'll continue with that. Sorry I didn't report it thru RDCC but since I had never worked with BigNum before, I had no idea what to expect from it so wanted to check with the community first!
Karen -----Original Message----- From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Jun 19, 2013 8:23 am Subject: [RBASE-L] - Re: 9.5 and BigNum At 11:53 AM 6/18/2013, Karen Tellef wrote: >Using build 0611 of 9.5, 64-bit. > >I have an integer column holding an invoice# and we want to create invoice >numbers greater than the integer limit. So we'd like to have a BigNum column >instead. > >Try #1: I tried doing an ALTER TABLE to simply change the datatype to >BigNum (11,0). >It works, but it put a decimal at the end. Although this works: > select all from acctrec where invno >= 1037005 >This does not work: > select all from acctrec where invno = 1037005 >I tried putting a decimal, a .0, etc., and I cannot get an "equal" to work. > >Try #2: So I added a new column to the table TestBigNum (11,0). If I >type in a >value, the "select ... = 1037005" works perfectly. So now to get >the data over >there... I tried: > UPDATE acctrec SET TestBigNum = InvNo >But I actually get the letters "NaN" in the column! > >Anyone have a clue how to get these old values converted into a >BigNum that is >searchable, or is this perhaps a bug (I've never used BigNum before) At 01:15 PM 6/18/2013, Kramer, Jason J wrote: >I think there is an error with the typecasting routine used to convert to a >BIGNUM. If you run the code below, you will see that you end up with a table >where the BIGNUM column is filled with textual entries that are the command >that fills them plus some extra garbage. If you issue the UPDATE itest1 SET >bigcol=intcol command from the command line instead of within the RMD file, >the result is just the text of the command in the bigcol without the extra >garbage. I'm going to report it via R:DCC. > >SET VAR viloop INTEGER = 1 >SET VAR virndval INTEGER = NULL > >CREATE TABLE itest1 (intcol INTEGER,bigcol BIGNUM (11,0),realcol REAL, >doucol DOUBLE) >WHILE viloop <= 1000 THEN > SET VAR virndval = (RANDOM(1999999999)) > INSERT INTO itest1 (intcol) VALUES .virndval > SET VAR viloop = .viloop + 1 >ENDWHILE > >UPDATE itest1 SET bigcol=intcol >UPDATE itest1 SET realcol=intcol >UPDATE itest1 SET doucol=intcol > >CLEAR VAR viloop,virndval > >RETURN At 12:52 PM 6/18/2013, Mike Byerley wrote: >Try to project a new table from the old one omitting the INTEGER col and >with Where count = 0, then add a BIGNUM col to that (with a different >colname), then do an Insert from the existing table, test that the new >table behaves properly and if OK, then drop your old table, rename, etc. At 01:01 PM 6/18/2013, Albert Berry wrote: >I fooled around here, and came up with the following from data types: >BIGNUM maps to DECIMAL >DECIMAL maps to DOUBLE >so I made a dummy database using an invoices table from another >database (59,000+ records) > >ALTER TABLE Invoices ADD InvNoBig DOUBLE >UPDATE Invoices SET InvNoBig = InvNo -- ERROR >UPDATE Invoices SET InvNoBig = (FLOAT(InvNo)) -- ERROR >UPDATE Invoices SET InvNoBig = FLOAT(InvNo) -- Yeah!!! At 10:53 PM 6/18/2013, George H Baker wrote: >Karen, > >Try a NUMERIC type designation> I use a Numeric 15 digit field. No decimal. > >This is an imported IDnumber on which I search and update records. It has >worked for me. I do no math with it but that should not be a problem. Karen, Jason, Mike, Albert, George, et al. You didn't have to find a workaround nor encounter such -ERROR- messages when using the BIGNUM data type in R:BASE eXtreme 9.5 (64). I am using R:BASE eXtreme 9.5 (64), Build: 9.5.2.20718, and everything works as it should. Jason, thanks for submitting a wonderful sample to the members of our eXpanded R:Dream Team. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
