SQL - Operators and Text fields

[Ruslan Zasukhin]

on 3/26/03 4:38 PM, Fitzbew at aol.com at Fitzbew at aol.com wrote:

> I have a baseobject that contains two text fields: from_MMDD and to_MMDD.
> 
> This sql syntax fails:
> 
> where from_MMDD >= to_MMDD
> 
> This sql syntax works fine:
> where from_MMDD >= '0701'
>                 
> Is there a particular syntax for using such comparison operators with text
> fields within
> the same baseobject? I need to compare the contents of the two fields
> themselves.

1) you can get this functionality with use of BaseObject methods.

-- you need create Method with formula:
            "_MMDD >= to_MMDD"

-- then use it in SQL query.


2) I wonder then, why you use TEXT fields ???
If you have big text, then no sense compare it.
If you have small text then better to use VarChar fields.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------