For those who are binary inclined a 4 byte integer can hold 32 bits. Unsigned it is 2*32-1. With one bit for the sign the largest number is 2*31-1, which is: 2,147,483,647.
Ken ----- Original Message ----- From: James Bentley Date: Thursday, April 10, 2008 11:14 pm Subject: [RBASE-L] - Re: integer value To: [email protected] (RBASE-L Mailing List) > Bernie, > > Following is from www.rsyntax.com. Datatype reference > > "INTEGER > · Holds whole numbers in the range of ±1,999,999,999 > · Delimiters (such as commas) cannot be used in entry > · R:BASE reserves four bytes of internal storage space" > > Make sure you value is truly defined as an integer. Also make > sure that no other part of you code such as RULES, STORED > PROCEDURES defines a limit on max value. What is the datatype > for "orderno" in the table. insert "SHO VAR ordno" into your > code to see what data type RBase has assigned. To the best of > my knowledge the datatype could be overridden by the select into > statement. > > --- Bernard Lis wrote: > > > Hello Experts, > > > > I have an integer column whose value has become greater than > > 970,000 > > This is the value of our Order Number > > So far no problems have been discovered using this number. > > I was under the impression that the max integer is 32,767 > > > > But today I tried to add one to the order number and the order > > number did > > not change. i.e. set var OrdNo = (.OrdNo + 1) > > > > Here is my code: > > set trace on > > set var OrdNo int=null > > sel orderno into OrdNo from dbcontrol I get 970115 > > set var OrdNo = (.OrdNo + 1) Ordno still is 970115 > > > > Then I did this > > set trace on > > set var OrdNo int=null > > sel orderno into OrdNo from dbcontrol I get 970115 > > set var OrdNo = (.OrdNo + 1) Ordno still is 970115 > > set var OrdNo = (.OrdNo + 1) Ordno doesn't change > > > > Anybody have a GhostBuster team? > > > > Bernie Lis > > > > > > > > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > >
