RE: TZF - limit on longint field?

...and therein lies the origin of the Y2K problem LOL. The assumption
that a programme, however trivial, has a limited life-span!


-----Original Message-----
From: Philip Kidder [mailto:[email protected]] 
Sent: 21 May 2003 14:26
To: [email protected]
Subject: Re: TZF - limit on longint field?


Lloyd,

I had this problem with a database in a program I had released for sale.
I
had defined the field as N,5,0. When the number got larger then 99,999
it
cycled back to 0. The field was a sequential counter that was used to
generate keys. That was a great mess to clear up. I redefined the
database
and set the field to N,10,0. That got me upto 9,999,999,999 before the
number would cycle back to zero. I figure I will be long dead before the
counter hits 10 billion and my program will be a very minor footnote in
the
history of programming.

Hope this helps.

Phil Kidder


----- Original Message -----
From: "Lloyd Edwards" <[email protected]>
To: <[email protected]>
Sent: Tuesday, May 20, 2003 11:28 PM
Subject: TZF - limit on longint field?


> Thanks for the good responses.
> I've run into another interesting problem. I'm populating a table with
> numbers. One field is a longint (Number) field. If I try to put a
number
> greater than four digits, a 0 is loaded in the field. I'm stumped. I'm
> positive that a longint can hold many more than four digits, but
haven't
> been able to work around it. All the other fields load just fine.
> Thansk for any help.
> Lloyd Edwards
>
>
>

==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
==^================================================================