SQL - Operators and Text fields

[Ruslan Zasukhin]

on 3/27/03 4:13 PM, Fitzbew at aol.com at Fitzbew at aol.com wrote:

> 
> In a message dated 2003/03/26 9:53:49 AM, sunshine at public.kherson.ua writes:
> 
> 
> 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
> 
> 
> Ruslan, you're the greatest.
> 
> I've built a boolean baseobject method that compares the two fields.   I can
> open the db in the VAPP application and I see that the method values are being
> populated correctly.
> 
> Still, when I include the method in an SQL query like this:
> 
> "and baseobject.mo_fgtt >= 1 "
> 
> the query still fails --- returns no records. (Changing the 1 to a 0 still
> returns no records.)
> 
> The method calculation is: "from_MMDD >= to_MMDD" and, like I said is a
> Boolean.
> 
> I'm sure I'm doing something wrong syntax-wise, but I am baffled.

Have you try do search in VAPP ?

In Record Browser, press CMD + F
Enter 1 and press enter.

May be problem with indexes. Try to reindex....

Ah!!!!!

You have made it as boolean?

Please change it to BYTE type. Boolean do not works for Methods.


-- 
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
-------------------------------------------------------------