Yes, Albert, that actually is one of the things we're considering. The only
problem with Text is that it behaves differently when sorting and searching
("between", etc). We would like it to behave like a number.
But in any case, for future reference, I sure would like to know how BigNumn
works!
Karen
-----Original Message-----
From: Albert Berry <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tue, Jun 18, 2013 11:13 am
Subject: [RBASE-L] - Re: 9.5 and BigNum
Karen, have you thought perhaps of using a TEXT 12 or 14 column?
ALTER TABLE invoices add TextInvno TEXT (14)
UPDATE invoices set TextInvNo = (RJS(CTXT(InvNo),14))
Albert
On 18/06/2013 9:53 AM, 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)
>
> Karen
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2013.0.3345 / Virus Database: 3199/6420 - Release Date: 06/18/13
>
