Subject TIBOQuery and Case Sensitivity
Author Jack Mason
We are using a TIBOQuery to access an indexed field in our database. We
know how to make a TIBOTable case insensitive, but that method does not
work for the query, and fails to compile. Is there a comparable method
for the query?

For the TIBOTable we do

with MainForm.OrderTable do
begin
with IndexDefs[1] do
begin
CaseInsFields := 'TITLE';
Options := [ixCaseInsensitive];
end;
end;

We want to be able to do

TIBQuery.SQL.Text := 'SELECT * FROM ORDERED WHERE ISBN=''' + ISBN_Text +
'''';

and have the records located whether the filter value is 000000000x or
0000000000X. Is there a way to do this with TIBOQuery?

Thanks