Subject Re: [IBO] TIBOQuery.Locate
Author Helen Borrie
At 10:26 AM 23/04/2003 -0300, you wrote:
>Hi Jason,
>At April 23, 2003, 04:15, Jason Wharton wrote:
> > Will someone please send me a sample application with this parsing problem?
>I was able to correct the problem by make the following changes in the
>IB_Parse.pas unit:
>Line 1732:
> FirstPos := pos('FIRST', tmpStr);
>New Changes:
> FirstPos := pos('FIRST ', tmpStr);
>Line 1739:
> FirstStr:='First '+getValue(tmpStr,FirstPos+5, PosEnd);
>New Changes:
> FirstStr:='First '+getValue(tmpStr,FirstPos+6, PosEnd);
>I know that there might be a better fix by analyzing the value
>returned by getValue to make sure that it is accepted when using
>FIRST. The same would go for SKIP. For the moment the changes above
>work for me. If you want, I can try to come up with a better fix and
>send it to you.

Do you have time to test your fix on a column name like "FIRST NAME"? Such
an identifier is valid inside dblquotes. I suspect that the problem will
persist in a case like this...