UTF sorting and blank fields, and UTF-8

[Dave Addey]

Hi Ruslan,

Yes, this is in the constructor, and I have a new database created with this
structure.  It seems as though when I do "SELECT * FROM songs", the *
doesn't return the ArtistNameIsBlank field as part of the results, and that
this is why I cannot sort on this field.  If I try "SELECT ArtistNameIsBlank
FROM songs", then the method values are returned correctly.  Is this the way
it's meant to be?  Are method fields not included in the results from
"SELECT *"?

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Mon, 12 Dec 2005 22:17:05 +0200
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: UTF sorting and blank fields, and UTF-8
> Subject: Re: UTF sorting and blank fields, and UTF-8
> 
> On 12/12/05 10:00 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
> 
>> 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?
> 
> You have add above field into constructor of your table?
> 
> And you create new db on disk ?
> 
> May be some error was and field is not valid in fact.
> You can check db by vstudio
> 
> 
> 
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina