Returning a partial string

[Ruslan Zasukhin]

On 7/8/05 7:08 PM, "jda" <jda at his.com> wrote:

> Hi Ruslan,
> 
> So far, no success. Here is what I tried:
> 
> I added this to the table:
> 
>    firstAuthorSortMethod = CreateTextField("firstAuthorSortMethod",
> 128, EVFlag.fNullable, "Left(authorsSortMethod, (LOCATE(chr(13),
> authorsSortMethod)))")
> 
> where
> 
>    authorsSortMethod = CreateTextField("authorsSortMethod", 128,
> EVFlag.fNullable, "left(authors, 256)")
> 
> 
> Then in my code, I used:
> 
> 
> select firstAuthorSortMethod,thedateSortMethod, * from thereferences
> where hit>0 ORDER BY firstAuthorSortMethod,thedateSortMethod
> 
> 
> (I also tried ORDER BY 1,thedateSortMethod)
> 
> The result is not sorted at all (or at least there is no pattern I can see).
> 
> What am I doing wrong?

Hard to say.

Can you send us some test db ?

Does that methods show correct values in viSQL or 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]