>When i run requery(stockview)
>it said "alas not found" , I also try it in the commmand window ,it also fail.
>(i am using vfp3.0)
>Do I need to put the view in the Data environment?

VFP 3.0 ??
Tore broke my ribs here last year, for using VFP6 way bejond VFP9 release date <vbg>
Consider yourself lucky :)
(for having working app with 3.0).