Dear Jason,
I've tried just now last Beta version 4.7 beta 14 as suggested by You.

But the error is still coming up.
Even i enter manually

IB_Q_T->Locate("TITOLO", "NOME A", SearchOptions)

I got the same.
It seems really the space character not ok for Locate, wherever it is.

As my needing is to take out the space after the text i've used s=Trims(s); where s is defined as String.
And actually is working for this simple project. But if i will need to search a text with space inside in the future?

With Many thanks for Your comment.

Have a nice weekend!

Regards,
Enrico

----- Original Message -----
From: Jason Wharton
To: IBObjects@yahoogroups.com
Sent: Sunday, January 14, 2007 5:58 AM
Subject: RE: [IBO] Fw: Locate with spaces


Please be specific about what you consider the latest to be.
If you have a bug case please send it to me and I'll get a fix in the next
beta of IBO 4.7.
I have fixed a couple parsing issues that had to do with Locate() method.
I am soon to release IBO 4.7 Beta14 for testing.
I'd appreciate it if you got that and tested.
Let me know if you need to URL to access it.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Enrico Cima
> Sent: Saturday, January 13, 2007 5:06 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Fw: Locate with spaces
>
>
> Dear Group,
>
> Thanks to Jason, i've upgraded to last version of IBO and
> while recompiling my little project i've entered in a problem
> with locate:
>
> While getting the content of the Row through the line during
> an OnCalculateField event with:
>
> s=ARow->ByName("TITOLO")->AsString;
>
> I'm gettintg the long lenght of the field fullfilled of
> spaces where no text present on left part: Es: s="ABCD
> ".
> This the same in previous version of Ibo.
>
> But while i'm then calling.
>
> if (IB_Q_T->Locate("TITOLO", s, SearchOptions))
>
> I'm getting the error:
>
> SQL error code = -104
> Token unknown - line 4, char 6
> ,
> '.Process stopped.
>
> This what not happening before, while i was using an older
> version of IBO.
> From some research in the messages, i found some threads
> about this matter, but i've not found a solution. Most
> probably becase locate do not want to have in the search
> field any empty space.
>
> What can i do? I need to check every string passed to locate
> if contain or not spaces? Or maybe there is another solution to this?
> Your help will be very appreciated.
>
> Using CBUILDER 6, FIREBIRD, IBO last version.
>
> Regards to All!
>
> Enrico
>





[Non-text portions of this message have been removed]