ORDER BY - some success

[john roberts]

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

> I am trying to query the database for all "Dessert" recipes and sort
> the results first by Cuisine, then by Name and I put the results in a
> list that shows all the Dessert recipes of a particular Cuisine grouped
> together and -- ideally -- in alphabetical order. It is this last bit
> that is not happening -- ie. no sorting of the recipe by name. Here is
> my query:
> 
> c = new vCursor(myDataBase,"select
> RecID,rname_fld,cuisine_fld,nameSort_fld from recipes where type_fld =
> 'Dessert' ORDER BY cuisine_fld, nameSort_fld")
> 

Hi, Rick.

Two questions:

1) Did you try your query in VAPP. If so, how do the results compare ? If
not, you might try it and compare.

2) Does the RB-V4RB query always return the same (bad) ordering ?

John Roberts