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]