|Subject||Re: [IBO] Locate problem with beta 4.7 beta 11|
> What was fixed in IBO was the underlying problem of IBO not putting theRight, I thought "locate" was a client side thing only.
> locate query on the server together correctly. When doing that I have to
> take into consideration of the underlying column name because that is the
> data I need to look through. I believe it will allow the locate on either
> the underlying SQLName or the actual AliasName of the column as far as
> identifying what column is being searched against.
> Obviously, if there is ambiguity that the alias is required todistinguish,
> then it is the responsibility of the programmer to be sure they do theHave you considered the case where there's no column name?
> locate based on the alias and not the potentially ambiguous SQLName.
select 'test', *
Imagine "test" coming from some formula or whatever...
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!