Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table insert from combobox
Message
From
05/12/1999 12:23:10
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00298163
Message ID:
00298895
Views:
18
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
Next
Reply
Map
View

Click here to load this message in the networking platform