At 10:38 PM 4/10/2008, Bernard Lis wrote:
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
Are you sure that the column data type is INTEGER and not the NUMERIC
with specific precision (the total number of digits)?
LIST tablename should reveal the actual data type with defined number
and precision.
Very Best R:egards,
Razzak.
