Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox in grid - 1st keypress clears drop down?
Message
From
13/12/2006 07:03:00
 
 
To
13/12/2006 06:49:00
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01175455
Message ID:
01177113
Views:
10
I think I may have found out why my combo keeps closing as soon as I type anything: since the project I am working was developed by someone else, I decided to double check the RowSource table used to populate the list. It is a free table, and I noticed a logical field named DELETED. There are 2 index tags that include "FOR ! DELETED". When I issus a REINDEX command, it says "6 records indexed". But there are over 100 records that meet the FOR ! DELETED criteria. When I SET ORDER to either of these tags, only 6 records display. So I think I finally have something that explains this weird behavior. I'll update this thread when I sort it out...

As for your combo classes - I am not avoiding them. But all I've seen so far was a paper from 2000 called ComboInGrid. Some of the issues listed in that paper have been fixed in subsequent releases of VFP, other things have changed (_IncSeek added in VFP 7). But it sounds like you have a more current paper? I'll have to check your site again. One time I stumbled into a link that took me to VFP Advisor site, which required I be a subscriber (I'm not)...



>One problem that I still have not figured out is: why does the combo's dropdown list close as soon as I type any character?
>
>Uhhmmm - something in your code? This is not native behavior.
>
>I did just discover that incremental searches are governed by the new _IncSeek system var (used to be _DblClick) and thought maybe the default of .5 was my problem. But increasing it to 4 seconds did not help.
>
>_Incseek affects Incremental searchinf when the combo's style is 2-dropdown list.
>
>I do not understand why you do not use the combo classes that are on my web site> They work properly.


Update: There was nothing wrong with the indexes - it turns out one of the tags is set for UNIQUE - so VFP listed only 6 records indexed since there were only 6 unique recs...

The odd behavior with the combo's dropdown closing as soon as I hit any key has something to do with the fact that some other columns have their ControlSource set to fields in the Products table. The combo's RowSource is Products.ItemCode, ItemDesc. VFP seems to want to update something every time I press a key while in the dropdown. This is driving me insane :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform