>I faced a problem that, VFP unable to retrieve records from SQL server using remote view. It only happen once a while, especially in networked environment.Well, you are not saying much. What do you mean by "unable to retrieve records"?
1) Did you get an error?
2) Did you get a -1 result?
3) Did you get a positive result and no records?
If:
1) what error?
2) what does the ODBC error message say? -- check AERRORS()
3) Check your query conditions as a view is just a saved query.