Getting LIKE %you%

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Chuck Pelto
> Sent: Friday, May 25, 2007 12:57 PM
> To: Valentina Developers
> Subject: Re: Getting LIKE %you%
> 
> Hi John,
> 
> On May 25, 2007, at 10:47 AM, Sims, John (CDC/CCHP/NCBDDD) 
> (CTR) wrote:
> 
> > Did you ever post what type of field tbl_cont.cont_namecomplete is?
> 
> cont_namecomplete is a VString VField. "May" is a middle name 
> of a person.
> 
> Looking over Steve's comment "I just opened this file in 
> BBedit with no errors but I don't see your error number...", 
> I used his technique of opening the error code files in 
> TextEdit, and much to my dismay, he is right. 460037 is NOT in there.
> 
> Looks like Valentina has a serious BUG in it, sending out 
> error messages that cannot be interpreted to allow the coder to debug.
> 
> Regards,
> 
> Chuck

Hi Chuck,

In the past, if the error code was not in the XML file, that usually
indicated that it was an error external to Valentina (eg. OS error).

I did some digging and found this from a previous Valentina post:

<quote>
Ivan, I've managed to get another database to give the same error. It 
clearly has to do with deleting records -- possible it is related to 
Mantis bug 219, for which I provided an easy way to reproduce.

Anyway, the error is

Record "(null)" is locked in table "myTable".

and the error number is

460037

Closing and reopening the database does not fix this error.
</quote>

One more thing, have you tried:

SELECT recID, * FROM tbl_cont WHERE cont_namecomplete REGEX '%may%'

Though the % might need to be changed to another character (sorry, not
real up on my REGEX at the moment).

-John