Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table insert from combobox
Message
From
05/12/1999 12:34:04
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00298163
Message ID:
00298907
Views:
23
If I have few items I populate them using AddItem or AddListItem. If I have 100 items I use cursor. If I have more I use grid.
BTW, your venerable VB populates all combos manually.

>Oh, so you manually populate your combos? What do you do when you have 100 or so items in a lookup? Do you use AddListItem?
>
>Please continue....
>
>You must have some very code intensive applications...
>
>>Value will be empty, but not necessarily DisplayValue combo.style=0). So, follow your suggestion, a user can pick-up empty item, and your code will think that this is new displayvalue, and attempt to insert new empty record to lookup table.
>>I write it specisically for you, not for a sake of logics.
>>
>>>I think you are looking at this in a backwards fashion...
>>>
>>>The FK will not correspond to a value in the rowsource, and as such, the displayvalue will be empty
>>>
>>>Often however, folks do place empty values in the database. Nothing wrong with that approach.
>>>
>>>I know what you are saying here. The logic you are throwing out here however, does not jive...
>>>
>>>
>>>>What, if you have empty item within a list? Should I proceed with 'Gee..' line now?
>>>>
>>>>>Ed...
>>>>>
>>>>>Often, if not most of the time, the displayvalue NEVER equals the value. The best solution is the one he found himself: If Empty(This.Value)... Gee, and he isn't an MVP.
>>>>>
>>>>>>>IF NOT (This.Value==This.DisplayValue)
>>>>>*** insert record into table etc.
>>>>>>>ENDIF
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform