Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lookups
Message
 
 
To
19/12/2001 11:27:27
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Miscellaneous
Thread ID:
00595992
Message ID:
00596244
Views:
19
I agree with Robert in that your views are probably being opened with the NoDataOnLoad property set to TRUE or a USE lv_AcctType NODATA is being issued.

In the LOAD method of the form, try the following:

REQUERY('lv_AcctType')

Or if the BizObject has a Requery method, call that method using their syntax. My guess is it would be something like

AcctType.Requery(view_name, parm2, parm3, etc.)

If the the view is parameterized, you need to set the value of the parameter first in the first example above. If you call the BizObj requery, then you would pass this as a parameter.

>The lookup is to fill a field called accttype from the gl table. I have the following set:
>
>BoundColumn = 1
>BoundTo = .T.
>ControlSource = v_gl.accttype
>RowSourceType = 6
>RowSource = v_accttype.AcctType, description
>ColumnWidths = 30,100
>ColumnCount = 2
>
>My views are simple. lv_gl has gl.Account#, Description, accttype
>lv_accttype has accttype.accttype, description
>
>Nothing is being loaded into the combobox so its almost like the box isn't recognizing the view's data. The views work fine by themselves - no filters or anything.
>
>I have a bizobj called Accttype that is enabled, is not the primary bizness object and has classname of accttypeenvironment, data access is v_accttype. There is no unique id field set.
>
>I was thinking - this v_accttype view is the same one I use for my acctype maintenance form so it is updateable. Could this be the problem? Do I have to create another view that is not updateable?
>
>Thanks for all your help.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform