Good thought. Nope, gives me the same thing Karen
-----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Jun 18, 2013 11:36 am Subject: [RBASE-L] - Re: 9.5 and BigNum A thought on your try #2 - try FLOATing the invoice number when you do the update. UPDATE ... SET TestBigNum = (FLOAT(InvNo)) That might get the update to work. Albert > > 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 > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com>
