Comparing two fields in a cursor

[Ruslan Zasukhin]

On 11/26/06 1:40 PM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

> Ruslan,
> 
> if I have Table A:
> 
> x    y    z
> 
> I want to do this:
> 
> cursor=select z from A where y<z
> 
> but it doesn't work. I can make it work if I define a
> BO Method that compares y to z, but is that the
> only/best way?

In v1 this not work right in SQL query.

You need make "BaseObject Method" with such formula "y < z"
And use it


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]