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.
----- Original Message ----- From: "Karen Tellef" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 18, 2013 11:53 AM Subject: [RBASE-L] - 9.5 and BigNum 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) Karen
