Data type for version-like number formating.. 1

[jong794613]

Hello,
What kind of data type should I use in case of this:

1.01.00
1.01.01
1.01.02
1.02.00

I know that a text field can be an option but it has to be numeric(?) in order to query something like this:

The parent data of 1.01.02 has to be 1.01.00

Thanks in advance..

 

[markros]

You can have 3 fields (

PluralSight Learning Library

 

[jong794613]

humm.. I thought that.. but there has to be another way..

 

[bborissov]

Then save the version w/o points:
[tt]
1.01.00 -> 10100
1.01.01 -> 10101
1.01.02 -> 10102
1.02.00 -> 10200
[/tt]

Adding missing points in appropriate places are your FrontEnd job

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.