You don't state whether or not the live version is on a network or not but for my answer I'll assume this is the case. What I do is, all development and testing is done locally with local test data. The live version on the network has the same database and tables in the same relative path. i.e. local data is C:\DATA\mydata\ and live data is :\DATA\mydata\. In the DE.BeforeOpenTables I have a line for each Cursor like the following: This.Cursor1.Database='\DATA\mydata\mydatabase'. The EXE on my C: will use local data and the EXE on network will use live data. HTH
>Hi, > >I have what seems like a fairly simple question, but I find it quite puzzling. I am going live with my first VFP 5.0 application in a week. I want to keep two sets of data. Firstly, the live data which everything is set up to now, and secondly a practice database, which contains a copy of the complete database for testing purposes. Obviously I want to use the same forms and classes in both systems. Back in the Procedural days with Clipper this was easy, but it seems even though I have created a practice database all the forms are still using the data in the live database. Is there an easy way to swap back and forth between Live mode and Practice mode? > >TIA, Peter Renton
Colin Magee Team Leader, Systems Development Metroland Media Group Ltd. Mississauga, Ontario, Canada
