Getting LIKE %you%

[Bart Pietercil]

As an example of catching Valentina exceptions:


   if  myConnection.IsConnected Then

     mySRV = new VServer(myConnection)

     mybbDB = new VDatabase(myConnection)
     f = GetFolderItem(DBName)
     try
       mybbDB.Open(f)
       'Return True
       if myConnection.IsConnected Then


         Return myConnection.IsConnected
       end if

     catch err as VException
       MsgBox err.Message
       return False
     end
   end if


So use Try.....Catch err as Vexception........end



hth

Bart Pietercil


On 25-mei-07, at 14:24, 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