Subject | TIBOQuery and Case Sensitivity |
---|---|
Author | Jack Mason |
Post date | 2003-04-02T23:27:02Z |
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
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