>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?
You need to pass the alias as a string, like Tore said:
requery("stockview")
Check in HELP if REQUERY() function exists in VFP3. I am not sure at all.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.