Select command using right

[RBtools]

Thanks for the information.  I changed it to a byte and it works great.
I was having some trouble with boolean and my select statement, but with the
byte is works fine.

Steve

on 2/18/03 5:04 PM, Robert Brenstein at rjb at rz.uni-potsdam.de wrote:

> Unless Ruslan has finally implemented support for Boolean methods,
> who are setting yourself for trouble. This was discussed quite a bit
> in the past. See for example:
> 
> http://www.leafe.com/archives/showMsg?cMsgNum=114527&listname=msgScan.fcgi
> 
> Robert
> 
> 
> 
>> The solution that I got to work (before I received your email) was to create
>> a method that used the right command.  I sent the method up as a boolean so
>> I can quickly check to see if the condition is met.
>> 
>> Thanks for the help,
>> 
>> Steve
>> 
>> on 2/18/03 2:17 PM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:
>> 
>>>  on 2/18/03 8:01 PM, RBtools at RBtools at columbus.rr.com wrote:
>>> 
>>>> 
>>>>  I am having a problem with a select command.
>>>> 
>>>>  select * from ReportTCP where Right(UserName,2) like  '24'
>>>> 
>>>> 
>>>>  I want to find all of the UserNames that end in 24.  Every time I
>>>> try this I
>>>>  get nothing back from the database.  I know that I have at least one
>>>>  UserName that ends in 24.
>>>> 
>>>>  UserName is a string[64] and the name that I am looking for only has 4
>>>>  characters in it.
>>> 
>>>  1) you get nothing because you CANNOT use functions directly in SELECT
>>>  For current Valentina version.
>>>  You need use BaseObject methods for this.
>>> 
>>>  2) IF you need find string that end on 24 you need do
>>> 
>>>    WHERE UserName like '24\Z'
>>> 
>>>  Where \Z is anchor of Regex search that means "End of line"
>>> 
>>>  Please read RegEx docs to select correct Anchor for you.
>> 
>> _______________________________________________
>> 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