Getting LIKE %you%

[Chuck Pelto]

I've been through every Valentina 2 document I have, Reference,  
Database Kernel, SQL and I cannot find any mention of an error code  
#460037.

Where can I find out what this arcane code means so I can try to FIX  
the problem? Where is the necessary documentation?

Regards,

Chuck

On May 25, 2007, at 6:31 AM, Chuck Pelto wrote:

> AH HAH!!!!
>
> I added Valentina.ThrowException = false to the opening method.
>
> I am NOW getting an error at the SQL call.
>
> Where can I find the REAL meaning of error # 460037?
>
> Regards,
>
> Chuck
>
> On May 25, 2007, at 6:24 AM, Chuck Pelto wrote:
>
>>
>> On May 24, 2007, at 3:01 PM, Barry G. Sumpter wrote:
>>
>>> Select *
>>> FROM [Documents]
>>> WHERE Path
>>>  LIKE '%Valentina%'
>>> AND  [FileName]
>>>  LIKE '%Microsoft%'
>>
>> So, my search text...
>>
>> SELECT recID, *
>> FROM tbl_cont
>> WHERE cont_namecomplete LIKE '%May%'
>>
>> ...seems to be okay.
>>
>> There must be some other problem at work here. Perhaps something  
>> to do with Valentina; an error that I'm not catching.
>>
>> Looking over the reference for Valentina2, I'm noticing the  
>> ThrowExceptions property. Heretofore, I had a check for errors in  
>> SQL calls based on ErrNumber, i.e.,  errNum =  
>> App.tDatabase.ErrNumber, was called after each SQL search. If the  
>> value was not 0 a message would appear citing the error number.
>>
>> I'm not sure what to make of throwing an exception. The  
>> documentation is rather vague to me on that point. What is meant  
>> by 'throw exceptions', as stated on page 17 of  
>> V4RB_Reference_2_en.pdf?
>>
>> As it reads...
>>
>> If this property is TRUE (default value) then Valentina for  
>> REALbasic 2.0 or new will throw
>> REALbasic exceptions. Otherwise Valentina 2.0 will not throw  
>> exceptions and you need
>> check the property VDatabase.errNumber to see if a Valentina call  
>> was successfull.
>>
>> Regards,
>>
>> Chuck
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>