Paradox Community

Items in pnews.paradox-programming

Subject:Re: Number Format
Date:Wed, 23 Sep 2020 18:30:16 +1000
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-programming
What's the business logic behind this?


On 23/09/2020 2:06 pm, Peter wrote:
> I cannot use rounded figures.
> 
> I use these numbers for unique ID ("EntryID") in the first field of my 
> table. I need to be able to insert new records in between sequentially 
> numbered records:
> e.g.
> 1
> 2
> 3
> 4
> 5
> 
> May need to become
> 1
> 1.1
> 2
> 3
> 4
> 5
> 
> Further it may need to become
> 1
> 1.01
> 1.02
> 1.03
> 1.1
> 2
> 3
> 4
> 5
> 
> Getting crazy
> 1
> 1.01
> 1.001
> 1.002
> 1.02
> 1.03
> 1.1
> 2
> 3
> 4
> 5
> 
> 


Copyright © 2004 thedbcommunity.com