Posted by: one
If a table has a column that is indexed, how to remove the index
properties from that particular column. Let say the table name is Hello
and the indexed column is Name.
How to control the dropdownlist (from visual tool chest) so that when I
click a key from the keyboard (for example "A"), and it would scroll and
put the focus to the first key that correspond to the input? I've tried
but fail to achieve that as if the scrolling of the dropdownlist is not
working. Does anybody have the same problem or have tried something
similar? Using the normal combo box can easily do that except that it
can only store one column of list.
Thank you in advance.
- Site Admin
- Posts: 2171
- Joined: 04 Mar 2017, 18:34
- Location: Palm Springs, California
Posted by: Jeff Luther
I'll respond to your index question below:
JL: I think you need to DROP the index that references Name and reCREATE
that index without Name. If you using SQLBase, here's a query I use that
lists all the user-defined indexes and tables/columns referenced:
select CREATOR || '.' || TBNAME, TBCREATOR || '.' || NAME, COLNAME, UNIQUERULE, COLSEQ
from SYSINDEXES, SYSKEYS
where NAME= IXNAME and NAME not like 'SYS%'
order by TBNAME, NAME, COLSEQ;
Be sure you recreate the index with all the other columns.
Jeff Luther/PC Design
Who is online
Users browsing this forum: [Ccbot], [Semrush] and 0 guests