ORDER BY sort command

[-= JB =-]

The field type of LName is kTypeVarChar

How do I check for IndexbyWords flag?

if I get VField_IsIndexed(fldRef) it is True

I also noticed it does SORT by not properly
so I don't know what it is sorting by because
it is not ascending and it is not descending
on the field I was using.

The DB is 1.1MB

thanks,
-=>JB<=-

On Mar 27, 2008, at 1:47 PM, Ruslan Zasukhin wrote:

> On 3/27/08 5:52 PM, "-= JB =-" <sundown at pacifier.com> wrote:
>
>> I spoke too soon.
>>
>> The code below is working without giving me an error but
>> it is sorting by ASCENDING not DESCENDING.
>
> What field type of Lname ?
>
> There is no IndexbyWords flag?
>
> If db is small you can send it to me off list
>
>
>> On Mar 27, 2008, at 8:47 AM, -= JB =- wrote:
>>
>>> Hi Ruslan,
>>>
>>> Thanks for the reply.  I have if figured out and like I said it was
>>> a stupid
>>> mistake by me.  Here is the code written properly and working:
>>>
>>> SELECT * FROM tblName ORDER BY LName DESC
>
> -- 
> 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
>