Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding records to a table via combobox
Message
 
To
06/05/1998 14:51:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00097388
Message ID:
00097754
Views:
19
***************************
From the Private messaging
***************************
>Nick -
>
>I put your code in my combobox (I used an insert into instead of append blank but otherwise the same), and for the first time it works! So, I wanted to thank you for that.
>
>But I do have a few questions based on other things I tried and something Cetin said (I still want to try that code):
>
>First, why did you choose Valid instead of LostFocus event as some others seem to recommend?

You can use it in LostFocus. In my case the reason was that I wanted code to fire without leaving my combobox control also.

>Also, I left my rowsource type as fields, whereas you have yours as Alias, but now mine seems to be working, so don't know what the difference would be.

No specific reasons, my combo I copied the code from had a RowSourceType = 1 (Value) :)

>I don't have any buffering in place for my Cities table right now, so don't know how Cetin's comment about that would impact.

If you have buffering enabled then you will need to use TABLEUPDATE() somewhere also.

>Even though this seems to be working, I still don't feel I have a good handle on the process, and want to understand the connections between these factors (i.e. why one thing works and another doesn't).
>
>If you want to answer in the public forum to both Cetin and me (so as not to repeat), that's fine. I just wanted to thank you for taking the trouble to email me your code.
>
>Sylvia

Well, Combobox and Grid are the most complicated and tricky controls in VFP, some workarounds we do for them should be just their native functions...

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform