Hi Naomi,

View parameters work well. The view works the way it should when opened manually (i.e. use xyz), and the business object also instantiates correctly when I do it through the command window.

Thanks!

Alex

Here's the view's code:

SELECT PADR(ALLTRIM(cfirstname)+" "+ALLTRIM(clastname),30) AS fullname,;
  Checks.ichecknumber AS check_no, Checks.dcheckdate AS chk_date,;
  Checks.ygross AS gross_amt, Checks.ydeduction1 AS circ_e,;
  Checks.ydeduction2 AS _765, Checks.ydeduction3 AS _2round,;
  Checks.ydeduction4 AS _093, Checks.ynet AS net,;
  Checks.ycheckamount AS check_amt, Checks.ccomment AS comments,;
  Checks.nregularhours, Checks.novertimehours;
 FROM ;
     checks ;
    INNER JOIN employees ;
   ON  Checks.iemployee = Employees.iid;
 WHERE  MONTH(dcheckdate) = ( ?vp_TargetMonth );
   AND  YEAR(dcheckdate) = ( ?vp_TargetYear );
 ORDER BY 1, Checks.dcheckdate

DBSetProp(ThisView,"View","SendUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","ytimeclock!checks")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".fullname","Field","DataType","C(30)")
DBSetProp(ThisView+".fullname","Field","KeyField",.F.)
DBSetProp(ThisView+".fullname","Field","Updatable",.F.)

DBSetProp(ThisView+".check_no","Field","DataType","I")
DBSetProp(ThisView+".check_no","Field","UpdateName","ytimeclock!checks.ichecknumber")
DBSetProp(ThisView+".check_no","Field","KeyField",.F.)
DBSetProp(ThisView+".check_no","Field","Updatable",.T.)

DBSetProp(ThisView+".chk_date","Field","DataType","D")
DBSetProp(ThisView+".chk_date","Field","UpdateName","ytimeclock!checks.dcheckdate")
DBSetProp(ThisView+".chk_date","Field","KeyField",.F.)
DBSetProp(ThisView+".chk_date","Field","Updatable",.T.)

DBSetProp(ThisView+".gross_amt","Field","DataType","Y")
DBSetProp(ThisView+".gross_amt","Field","UpdateName","ytimeclock!checks.ygross")
DBSetProp(ThisView+".gross_amt","Field","KeyField",.F.)
DBSetProp(ThisView+".gross_amt","Field","Updatable",.T.)

DBSetProp(ThisView+".circ_e","Field","DataType","Y")
DBSetProp(ThisView+".circ_e","Field","UpdateName","ytimeclock!checks.ydeduction1")
DBSetProp(ThisView+".circ_e","Field","KeyField",.F.)
DBSetProp(ThisView+".circ_e","Field","Updatable",.T.)

DBSetProp(ThisView+"._765","Field","DataType","Y")
DBSetProp(ThisView+"._765","Field","UpdateName","ytimeclock!checks.ydeduction2")
DBSetProp(ThisView+"._765","Field","KeyField",.F.)
DBSetProp(ThisView+"._765","Field","Updatable",.T.)

DBSetProp(ThisView+"._2round","Field","DataType","Y")
DBSetProp(ThisView+"._2round","Field","UpdateName","ytimeclock!checks.ydeduction3")
DBSetProp(ThisView+"._2round","Field","KeyField",.F.)
DBSetProp(ThisView+"._2round","Field","Updatable",.T.)

DBSetProp(ThisView+"._093","Field","DataType","Y")
DBSetProp(ThisView+"._093","Field","UpdateName","ytimeclock!checks.ydeduction4")
DBSetProp(ThisView+"._093","Field","KeyField",.F.)
DBSetProp(ThisView+"._093","Field","Updatable",.T.)

DBSetProp(ThisView+".net","Field","DataType","Y")
DBSetProp(ThisView+".net","Field","UpdateName","ytimeclock!checks.ynet")
DBSetProp(ThisView+".net","Field","KeyField",.F.)
DBSetProp(ThisView+".net","Field","Updatable",.T.)

DBSetProp(ThisView+".check_amt","Field","DataType","Y")
DBSetProp(ThisView+".check_amt","Field","UpdateName","ytimeclock!checks.ycheckamount")
DBSetProp(ThisView+".check_amt","Field","KeyField",.F.)
DBSetProp(ThisView+".check_amt","Field","Updatable",.T.)

DBSetProp(ThisView+".comments","Field","DataType","C(150)")
DBSetProp(ThisView+".comments","Field","UpdateName","ytimeclock!checks.ccomment")
DBSetProp(ThisView+".comments","Field","KeyField",.F.)
DBSetProp(ThisView+".comments","Field","Updatable",.T.)

DBSetProp(ThisView+".nregularhours","Field","DataType","N(6,2)")
DBSetProp(ThisView+".nregularhours","Field","UpdateName","ytimeclock!checks.nregularhours")
DBSetProp(ThisView+".nregularhours","Field","KeyField",.F.)
DBSetProp(ThisView+".nregularhours","Field","Updatable",.T.)

DBSetProp(ThisView+".novertimehours","Field","DataType","N(6,2)")
DBSetProp(ThisView+".novertimehours","Field","UpdateName","ytimeclock!checks.novertimehours")
DBSetProp(ThisView+".novertimehours","Field","KeyField",.F.)
DBSetProp(ThisView+".novertimehours","Field","Updatable",.T.)

>Can you post view code? Have you properly set parameters for the view?
>
>>Hi y'all,
>>
>>I have a view/bizobj combination that seems to be cursed. I can't figure out what might be the problem.
>>
>>I have a form that has a couple of methods that open business objects assigning them to locally-scoped variables in the form:

Local loChecks_bo
>>
>>loChecks_bo = CreateObject( "Checks_bo")

The above works fine.
>>
>>There is one particular business object (MonthlyChecksList_bo), however, that just refuses to work. Whenever the object is created, I get vfp's open dialog and I'm asked for a dbf. This happens in the business object's dataenvironment's OpenTables (MonthlyChecksList_bo.MonthlyChecksList_de.OpenTables()) method. In the line that reads "This.oDataEnvironment.OpenTables()".
>>
>>I've tried the business object in stand-alone mode (running setx and then instantiating the bizobj) and it's fine there.
>>
>>I have already re-created the view, the business object AND the view. Several times!! Still no luck.
>>
>>Does anyone have any idea of where and what I should be looking for? I'm very close to just hard-coding my "use" statements and foregoing the framework entirely to get to the data in this case.
>>
>>Thanks!!!!
>>
>>Alex