Will someone please send me a sample application with this parsing problem?

Thanks,
Jason Wharton
CPS - Computer Programming Solutions
Mesa Arizona
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, April 22, 2003 4:08 PM
Subject: Re: [IBO] TIBOQuery.Locate


> Hi,
>
> At April 22, 2003, 18:22, Sergey Kanovka wrote:
>
> > IBO 4.2.Id, Firebird 1.0.2.908, Delphi 7
>
> > I have a strange error when I try to locate a record in TIBOQuery. SQL
> > is pretty simple:
>
> > SELECT PERSON_ID
> > , FIRST_NAME
> > , LAST_NAME
> > , MI
> > , SSN
> > FROM PERSONS
> > order by last_name
> > for update
>
> > Delphi code:
>
> > PersonsQry.Open;
> > PersonsQry.Locate( 'SSN', Trim( SSNEdit.Text ), [] );
>
> > After Locate I get following error:
>
> > Token unknown
> > _NAME
>
> [...snip...]
>
> > which probably caused an error.
>
> > Any ideas?
>
> I'm kind of glad that I'm not the only one encountering a similar
> problem. I haven't found the solution either, as you can see I posted
> a message just a few hours ago. I think that both our problems are
> related. First point in common is that the query is generated by IBO.
> And second point, my error is generated by the field NAME, which NAME
> is part of a field name and your error is with _NAME, which is also
> part of one of your field names.
>
> I'm sorry I couldn't help you. I just wanted to let you know that
> you're not alone.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)