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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
