Paradox Community

Items in pnews.paradox-programming

Subject:Re: Query using Alpha field with Numbers
Date:1 Sep 2022 06:33:25 -0400
From:"Kevin" <shcsbaker@gmail.com>
Newsgroups:pnews.paradox-programming

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
>
>
>-- 
>Using Opera's mail client: http://www.opera.com/mail/


Copyright © 2004 thedbcommunity.com