Subject | TIB_LookupCombo case insensitive inc search |
---|---|
Author | Brian Dunstan |
Post date | 2000-11-29T03:04:19Z |
I think there is a problem with case insensitive searching using
TIB_LookupCombo.
Using the Samples\LookupCombo\LookupCombo.dpr sample program, I have run
this test.
1) Using WISQL I have inserted another department record 'corp x'.
insert into department values(
1,'corp x',null,105,100000,'Monterey','(408) 555-1234'
)
2) Run LookupCombo.dpr and type what you like into the Department
LookupCombo and you can't get to 'corp x'. The only way to select 'corp x'
is to scroll to the end of the list and click on it.
qrDept.AutoFetchAll is True
qrDept.ColumnAttributes contains 'DEPARTMENT=NOCASE=DEPARTMENT'
In a previous post a month or so ago, relating to search performance, Jason
said:
Am I just being a duffer (again) or is there really a bug here :-)
Any help in getting expected performance from this ubiquitous control would
be much appreciated :-)
TIA,
Brian
TIB_LookupCombo.
Using the Samples\LookupCombo\LookupCombo.dpr sample program, I have run
this test.
1) Using WISQL I have inserted another department record 'corp x'.
insert into department values(
1,'corp x',null,105,100000,'Monterey','(408) 555-1234'
)
2) Run LookupCombo.dpr and type what you like into the Department
LookupCombo and you can't get to 'corp x'. The only way to select 'corp x'
is to scroll to the end of the list and click on it.
qrDept.AutoFetchAll is True
qrDept.ColumnAttributes contains 'DEPARTMENT=NOCASE=DEPARTMENT'
In a previous post a month or so ago, relating to search performance, Jason
said:
> If you are pulling all the records to the client then there is noSo I think this is SUPPOSED to work, but it looks to me like it doesn't.
> appreciable benefit to having a dedicated column for the uppercase
> equivalent. IBO will perform it in memory as you expect.
Am I just being a duffer (again) or is there really a bug here :-)
Any help in getting expected performance from this ubiquitous control would
be much appreciated :-)
TIA,
Brian