SQL quirkiness

[jda]

On Oct 19, 2008, at 7:33 AM, Ernesto Giannotta wrote:

>
> Hi list,
>
> sorry for the huge delay but I've experienced a similar situation just
> yesterday
>
> I was looking for some field data beginning with "strange" (yep! the
> appropriate word :-) and the app kept crashing and no diagnose or
> reindex or clone did help (the crash log reported something wrong on
> dispose string or some like that, sorry I trashed it)
>
> After I added a record to the searched table the problem went away...
>
> Sorry, I can't be more helpful than this
>
>>

Interesting. I've had 3 reports from 3 different users of a problem  
where searching for

      left(theTextfield, 1)='a'

crashed, but any other letter is OK.

I got ahold of one example and reproduced it. Diagnose -> no problems.  
Clone did not help. In this case, adding more records did not help.  
The only way I could fix it was to export the data as text and  import  
it into a fresh database.

Jon