multiple questions - indexes and dropdownlist

forum.advanced.programming (2000-2005)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

multiple questions - indexes and dropdownlist

Post by NewsgroupServer » 06 Mar 2005, 07:40

 Posted by:  one 

hello NG,

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.

~ONE~

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

multiple questions - indexes and dropdownlist

Post by NewsgroupServer » 07 Mar 2005, 17:45

 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.

Best Regards,
Jeff Luther/PC Design
www.pulpcards.com/gupta/

Return to “advanced.programming”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests