FAN-tastic, Cetin. Thanks SOOOO much...this really got me going in the right direction, after being really stuck...you've made my day!


>>Hi,
>>I have a header table with entries for employers and End of quarter (EOQ) dates, one entry for each employer-EOQ combination. A detail table has one or more records for each employer-EOQ.
>>
>>I need to update records in both tables for an employer for one or more EOQs, but typically not ALL EOQs.
>>
>>So, I'm trying to figure out how to create updateable views that SELECTs one or more EOQs (I could use a view that collects all EOQs and just updates the EOQs i want to change, but that seems like overkill...the number of related records in the detail file may get very large).
>>
>>One solution I've read about suggested using a temporary DBC and creating the view w/the specific EOQs required.
>>
>>Is this the best way? I'd tried using view parameters, and IN/INLIST but couldn't get it to work with a list of dates.
>>
>>Any suggestions/comments? TIA, J
>
>Jill,
>Create a cursor and join with it. ie:
>
>

>Create cursor CntryList (Country c(10))
>
>* Create the view with a join
>CREATE DATABASE 'INQUERYTEST.DBC'
>CREATE SQL VIEW "CUSINSPECIFICCOUNTRY" ;
>   AS SELECT Customer.* ;
>   	FROM Customer ;
>    inner join CntryList ;
>   on CntryList.country = customer.country
>
>* other view properties here
>
>
>* Test
>Insert into CntryList values ('Belgium')
>Insert into CntryList values ('Germany')
>Insert into CntryList values ('France')
>
>USE inquerytest!CUSINSPECIFICCOUNTRY
>Browse
>
>Select CntryList
>Zap
>Insert into CntryList values ('USA')
>Insert into CntryList values ('Sweden')
>
>Requery('CUSINSPECIFICCOUNTRY')
>Select CUSINSPECIFICCOUNTRY
>browse
>

>Keep in mind "CntryList" is just an alias, it could be the name of a select into cursor. Before using your view (if not with nodataunload) make it availbale and before a requery of view repopulate it first. View itself is in your DBC and no additional DBC is created.
>Cetin