Paradox Community

Items in pnews.paradox-programming

Subject:Re: Query using Alpha field with Numbers
Date:Thu, 1 Sep 2022 09:12:41 -0500
From:Mark Bannister <markRemove@THISinjection-moldings.com>
Newsgroups:pnews.paradox-programming
You could add a master table to your version field that holds a numeric 
value or some sort of other sorting value(s).

On 9/1/2022 5:33 AM, Kevin wrote:
> I have values of ONL, Z, DEMO, 1, 2, 3, etc 23, 23.1
> 
> Currently I'm using the following in the version field to get anything >
> 20
> 
> 21 or 22 or 23..
> 
> at version 23 we started subversions
> 
> I think the above will just have to work for now.
> 
> modridirkac <jure.zorko@gmail.com> wrote:
>> What are values for version 7? "07" or "7" ?
>> Do you have subversions?  "25.1.2"
>>
>> In a query it would be imposible. You have to cut frrst part of value
>> ("25") and then convert it to number (25) and then check (>20).
>>
>> J.
>>
>>
>> On Thu, 01 Sep 2022 10:27:39 +0200, Kevin <shcsbaker@gmail.com> wrote:
>>
>>>
>>> I have a db with a "Version" field.  This field is a Alpha field.  Is
> it
>>> possible
>>> to build a query with criteria for version > 20
>>
>>
>> 
-- 
Mark Bannister



Copyright © 2004 thedbcommunity.com