ORDER BY

[Rick Robinson]

Ruslan,

You are right. It is, of course, a VarChar field, not a TEXT field.

Given that, why is my sort not working as expected?

Rick

On Wednesday, January 22, 2003, at 11:49  PM, Ruslan Zasukhin wrote:

> on 1/23/03 1:11 AM, Rick Robinson at rickrobinson at attbi.com wrote:
>
>> Next question...
>>
>> How does the SQL "ORDER BY" statement work in Valentina? I want to 
>> sort
>> a list of recipes by their name. The name, which can be up to 80
>> characters is stored in a text field. I'd like to also sort by the 
>> type
>> of recipe (Dessert, Appetizer, Beverage, Snack, etc.)
>>
>> I have a statement:
>>
>> c = new vCursor(myDataBase,"select * from recipes where cuisine_fld =
>> '" + t + "' ORDER BY type_fld, name_fld")
>>
>> Then I display these in a list in the order "name" followed by "type".
>>
>> I get all the recipes of a particular type grouped together in the
>> list. But, the names are not in alphabetical order with similarly 
>> named
>> recipes together. I might get recipes that start with the word
>> "Chocolate" spread around throughout the list. Is the ORDER BY sort a
>> strict alphabetical sort? Does the length of the text in the field
>> change the result?
>
> Hi Ric,
>
> You really use TEXT field ?
>
> No, for name -- 80 chars you need use VarChar[80]
>
> TEXT field cannot be sorted by definition.
>
> -- 
> 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
>