Search problem with V4RB4.8.1

[Ruslan Zasukhin]

On 4/11/11 4:23 PM, "jda" <jda at his.com> wrote:

Hi Jon,

A) diagnose
B) reindex

Not helps right?

Then I think best of all put into mantis some simple test db.

As I understand first query in Vstudio 4.7 and 4.8 will return different
results, right ?
 
Then we can test here and compare

> This search used to work with version 4.7
> 
> select 
> id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMe
> thod,thedateSortMethod
> from thereferences where RecID in (1) AND (left([allFields], 5) =
> 'adams') AND (left([allFields], 1) = 'm') ORDER BY
> authorsSortMethod,thedateSortMethod
> 
> Now it does not.
> 
> This search *does* work
> 
> select 
> id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMe
> thod,thedateSortMethod
> from thereferences where RecID in (1) AND (left([allFields], 5) =
> 'adams') ORDER BY authorsSortMethod,thedateSortMethod
> 
> and so does
> 
> select 
> id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMe
> thod,thedateSortMethod
> from thereferences where (left([allFields], 5) = 'adams') AND
> (left([allFields], 1) = 'm') ORDER BY
> authorsSortMethod,thedateSortMethod
> 
> 
> I see nothing wrong with the first search. Did something change
> between 4.7 and 4.8 that should affect this?
> 
> Jon
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 

-- 
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]