ORDER BY

[Ruslan Zasukhin]

on 1/23/03 7:44 PM, Rick Robinson at rickrobinson at attbi.com wrote:

> Okay, in my "recipes" base object in RB, I've defined a property like
> this:
> 
>  nameSortField as VVarChar
> 
> And, in the constructor method I've got the following definition:
> 
>  nameSortField = new VVarChar("nameSort_fld",80, "ASCII",KV_Indexed)
>  nameSortField.SetMethod("Upper(rname)")
> 
> Where "rname" is the VarChar field in the table that contains the name
> of the recipe.
> 
> Now, when I do the following query:
> 
>  c = new vCursor(myDataBase,"select RecID,* from recipes where
> type_fld = 'Dessert' ORDER BY cuisine_fld, nameSort_fld")
> 
> I get an empty cursor. If I remove the "nameSort_fld" from the ORDER BY
> list, then I get the right records (some 97 of them) in the cursor.
> 
> What gives?

Check in viSQL that new method returns you good values.
Do SELECT ** for this

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