Select statement question

[Ruslan Zasukhin]

on 11/13/03 6:46 AM, chuck hinkle at chuckbo at hinkles.us wrote:

> I've been trying to figure out what was wrong with my fieldnames or joins
> when I did a 
> Select min(ABC) as MinOfABC, max(ABC) as MaxOfABC ...
                ^^^^^^^^^^^^^

                Valentina 1.x do not support AS for a fields.

> and I just figured out that Valentina SQL doesn't take the AS command. So my
> question is, then, what fieldname do I use to retrieve these values from the
> cursor? I had been planning to use
>   myCursor.field("MinOfABC")

You can use simply 

    cursor.Field(1)
    cursor.Field(2)

-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------