This is the only place I'm opening it. I have nothing in data environment either. p2 should be able to contain names of any view I want it to be right?
>Dou you've database with view open?
>
>>I have two forms (form1 and form2). Form1 passes a parameter to form2 which contains the view name. The views are also parametized. so I do the following:
>>
>>
>>do form2 with hldid, lcdate, 'lv_offopt6'
>>
>>
>>when I go to form2 I have the following in the init:
>>
>>
>>parameter hldid, p1, p2
>>USE (p2) ALIAS tbl_view ORDER op_uniqueid
>> lcdate = (p1)
>> REQUERY(tbl_view)
>> seekval = INT(hldid)
>> SEEK(seekval)
>> .refresh()
>>
>>When I run the code, it thinks that p2 is a dbf file when it is actually a view that I am trying open. It gives me the following error
>>
>>
File 'e:\budget2002\lv_offopt6.dbf' does not exist
>>
>>I'm on the right track here, what is it that I am doing wrong?
>>Thanks
>>Nick Patel