[EMAIL PROTECTED] wrote: > My questions are: > 1. How do I place the DBC locally and still have the data on the server? > It's easy. You have the dbc locally, and put the data on the server! :-) Seriously, we do this all the time for one of our products. Our product uses views for all of the data I/O, and the data can be on the local machine, on a network drive, or on an MSSQL server backend. All you do is set up the connection settings in the DBC to point to the data location. Using a connection string makes it easier to do programmatically. One caveat - I recently found out the hard way, that if you have a local test data set on your machine, open the connection, and accidentally save it, VFP "helpfully" saves the hard-coded path to your data set. Larfs ensue when you deliver to the client. :-)
> 2. How does this affect Stonefield updates? > Not at all. I don't understand Stonefield, because I just learned enough to do my job, but we use it all the time, and it doesn't care. Someone else would have to give you the behind the scenes on this one. > 3. and How do I develop locally, and then deploy the finished product on a > server? i.e. dbc local, data on server. > We wrote some code, but basically, you ship the VIEW dbc in the same folder as your app, with no connection, have some code that programmatically builds the connection the first time the app is run (user interactive, so they can browse to the data), and then SET DATABASE to your view dbc on startup. > I place the dbc and related Stonefield files and Stonefield takes > care of the update. > I don't' understand Stonefield, but we use it to do data updates, so I know it works in the scenario you're describing. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
