Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot requery a view from a combobox
Message
From
27/08/2001 10:27:41
 
 
To
25/08/2001 20:21:39
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00548942
Message ID:
00549432
Views:
12
>>I have two forms one is the main form. This form is used to enter different informations. Amongst those informations is the name of a company.
>>
>>The other is a form that can be used by the user to add companies to the ones that already exist (in case the company is not already in the combobox of the first form). That form can be launched by the main one.
>>
>>I only use views in the data environment.
>>
>>I launch the main form and then from that form I launch the second one. I add a company. I save this new record. When I get back to the first form the combobox does'nt give me the new company name.
>>
>>Everything looks good when I look at it through the data session. The only thing is that even with a REQUERY in the GotFocus event the combobox does'nt requery.
>>
>>Is there something that I'm not doing right on the CodeMine side?
>>
>>What should I do to check or fix that problem?
>>
>>Perhaps this has no importance. I use the CodeMine framework.
>
>Maybe you should requery the view, too. Once you add a new company in the second form, you basically add it to the base table (specially if it uses a private datasession) ad the view you based your combo on is not aware of the new record. So you should first requery the view, then the combo.

I solved that problem another way. Instead of using SQL for the RowSourceType I'm using ALIAS. It was problably a problem with buffers.

Thanks for the reply Dragan.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Reply
Map
View

Click here to load this message in the networking platform