ORDER BY

[Rick Robinson]

Okay, I'll try this. When I do the ORDER BY statement do I use the 
field "myFieldSortMethod"?

Also, since these are methods, does their creation impact the actual 
database schema? I have an existing database with almost 400 records. 
Will I need to convert my existing database by adding these methods 
using Vapp? Or can I just add these as run-time activities in my 
program?

Rick

On Thursday, January 23, 2003, at 09:28  AM, jda wrote:

>> Sorry, but I don't understand what you mean by "define second index 
>> using BaseObject methods", Ruslan. Are there examples in the 
>> documentation that would show me what to do?
>
> Here's an example:
>
> //create field
>
>   myField = new VText("title", 128, "English")
>
> //now create method that returns field indexed by words and uppercased 
> (for case insensitive searches)
>
>   myFieldMethod = new VText("myFieldMethod", 128, "English", 
> kV_IndexByWords)
>   myFieldMethod.SetMethod("Upper(myField)")
>
> //now create method NOT indexed by words and return uppercased (for 
> case insensitive search/sort)
>   myFieldSortMethod = new VText("myFieldSortMethod", 128, "English", 
> kV_Indexed)
>   myFieldSortMethod.SetMethod("Upper(myField)")
>
>
> Jon
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>