G'Day Petras, < g >

>Hi, I have a VFP6 (SP5) application that opens a local VFP database that purely consists of remote views. As we all know, this database can become corrupted by PC crashes, [Crtl][Alt][Del] etc. Questions:

You just gotta love those Remote Views don't ya! < s >

>2) Is there any method of changing the way remote views are recreated? Currently when recreating remote views, each view seems to be generating an SQL command of "SELECT * FROM table" which on large tables and on a WAN can take a long time (several minutes).

Yikes!!! Talk about negating the whole "reducing network traffic" effect that client server apps have. What you need to do is re-work those views so that they only bring down the field required and/or add a parameter to them to reduce the number of records retrieved.

Either way, you're learning the hard way that RVs are no fun!