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
