UTF sorting and blank fields, and UTF-8

[Dave Addey]

Good news - I got this to work!  But, selecting / sorting on the method
field takes much longer, as the method has to be calculated on the fly.  Is
it possible to calculate the method field when the record is first created,
rather than when it is selected?  I could have a second field which I
manually set when adding the record, but it's nicer to have Valentina do it
using a method field if I can :-)

Dave.

> From: Dave Addey <listmail1 at dsl.pipex.com>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Mon, 12 Dec 2005 20:00:54 +0000
> To: Valentina Developers <valentina at lists.macserve.net>
> Conversation: UTF sorting and blank fields, and UTF-8
> Subject: Re: UTF sorting and blank fields, and UTF-8
> 
> I've been trying to get something like this to work, using:
> 
> ArtistNameIsBlank = New VLong("ArtistNameIsBlank", EVFlag.fNone,
> "IF(LENGTH(Artist)=0, 0, 1)")
> 
> ...but when I come to select with an ORDER BY of ArtistNameIsBlank, I get a
> Vexception of 'Field "ArtistNameIsBlank" does not exist'.  Any ideas why?
> 
> Dave.
> 
> 
>> From: Dave Addey <listmail1 at dsl.pipex.com>
>> Reply-To: Valentina Developers <valentina at lists.macserve.net>
>> Date: Mon, 12 Dec 2005 19:34:48 +0000
>> To: Valentina Developers <valentina at lists.macserve.net>
>> Conversation: UTF sorting and blank fields, and UTF-8
>> Subject: Re: UTF sorting and blank fields, and UTF-8
>> 
>> Hi John,
>> 
>> It sounds like a good plan!  I can't get it to work, but I'm new to method
>> fields - so if you can find the code you used, please do send it on :-)
>> 
>> All the best,
>> 
>> Dave.
>> 
>>> From: "Sims, John" <ayu8 at cdc.gov>
>>> Reply-To: Valentina Developers <valentina at lists.macserve.net>
>>> Date: Mon, 12 Dec 2005 13:35:25 -0500
>>> To: Valentina Developers <valentina at lists.macserve.net>
>>> Conversation: UTF sorting and blank fields, and UTF-8
>>> Subject: RE: UTF sorting and blank fields, and UTF-8
>>> 
>>>> -----Original Message-----
>>>> From: valentina-bounces at lists.macserve.net
>>>> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of
>>>> Ruslan Zasukhin
>>>> Sent: Monday, December 12, 2005 1:25 PM
>>>> To: valentina at lists.macserve.net
>>>> Subject: Re: UTF sorting and blank fields, and UTF-8
>>>> 
>>>> On 12/12/05 8:14 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
>>>> 
>>>> Hi Dave,
>>>> 
>>>>> I¹m a long-time V4RB 1.9, finally making the switch to V4RB 2.0.5.
>>>>> So, I have a few questions :-)
>>>>> 
>>>>> Firstly, is there a way I can get my SELECT statements to
>>>> order with 
>>>>> blank fields appearing *after* all other fields?  For
>>>> example, if I do
>>>>> "SELECT * from songstable order by album", I want everything with a
>>>>> non-blank VarChar in the 'album' table to come first in UTF sorted
>>>>> order, followed finally by all records with blank album fields.
>>>> 
>>>>> It seems that by default, blank fields come *first* when I sort in
>>>>> ascending order.
>>>> 
>>>> I see what you mean.
>>>> 
>>>> Right now no. But you can add feature request into our Mantis.
>>>> I believe we can easy implement this as property:
>>>> 
>>>>     Valentina.NullsAreFirst as Boolean = true
>>> 
>>> Hi Ruslan/Dave,
>>> 
>>> I seem to recall I was able to do something like this before using a Method
>>> Field.  I don't have any code in front of me but I think I created a method
>>> field that returned True if the length of the field was NULL (or length = 0,
>>> I
>>> can't remember).  Then I queried it with something like:
>>> 
>>> SELECT * FROM SongsTable ORDER BY IsBlank, Album
>>> 
>>> Since "False" comes before "True", it put my blank records at the end.  I'll
>>> see if I can find that code/DB tonight.
>>> 
>>> -John
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>> 
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina