Search problem with V4RB4.8.1

[Francois Van Lerberghe]

le 11/04/11 15:23, jda <jda at his.com> a écrit :

> 
> Hi Ruslan,
> 
> 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')

How could these conditions

    (left([allFields], 5) = 'adams') AND (left([allFields], 1) = 'm')

be true ??

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique