>I use a parameterized view to generate a set data that the user are autorized to see. eg.
>
>I use the following code to creat para view:
>
>SET EXACT OFF
>CREAT SQL VIEW vpohead AS;
> SELE po,date,amt,perinch,cusid,issue;
> FROM po ;
> po.perInCh = ?mPer ;
> ORDER BY 1
>
>Then I link source table with this view. So if user move the record in view, the source table will also move to same record.
>
>My problem is if the user add/edit a record, which way is better to handle the situation,
>
>1)insert/update the record to both view and table or
>2)insert/update the record to source table and requery the view.
>
>Any other suggestion ?
>
>TIA
Why do you create the view on the fly?
Why not create it at design time,
USE
it when necessary and update the table through the view?
Insanity: Doing the same thing over and over and expecting different results.