ORDER BY

[Rick Robinson]

I also get an empty cursor in ViSQL. If I look at the base object 
structure, my new method fields do not show up. Is that right?

If I remove the "nameSort_fld" from the ORDER BY statement, then I get 
records.

Rick

On Thursday, January 23, 2003, at 10:54  AM, Ruslan Zasukhin wrote:

> 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
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>