Min/Max Retrieval

Sat Mar 8 21:45:36 CST 2003

on 3/8/03 5:38 PM, fitzbew at aol.com at fitzbew at aol.com wrote:

> Name:      Russ Tyndall
> 
> Question regarding: v4rb

Hi Russ,

> Using 1.9.7: 
> 
> When I build a vCursor using:
> &#34;rstDB =   dbAvx.SqlSelect(&#34;Select Max(&#34;date_from_YYYY&#34;) from
> mainrecords&#34;)&#34;
> 
> and date_from_YYYY is a String field, what is the syntax for retrieving the
> Max value into another variable?  Everything I have tried has failed.  Can
> find nothing in the docs about this specifically.

    varStr = rsDB.StringField(1).value

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