UTF sorting and blank fields, and UTF-8

[Dave Addey]

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