I have an application in 4.2 where I created a business object that loads two cursors: lv_address and rv_address_lookup. The preferences are set to use local data. Both views exist in the same database. In the dataenvironment I set rv_address_lookup to 2-USE REMOTE DATA override. The idea is to pull some data from a remote data source and load it into a local cursor. Eventually I want the ability to set my preferences to use remote data and work with a seperate database. In other words, pull from a remote database and load it into another remote database. (If you havn't guessed, I'm building a Data Warehouse. I'm prototyping the warehouse in VFP and upsizing to SQL. The source data is in IMAGE/SQL Yuck!!!!) This all worked like a charm until 6.0

In 6.0, the OpenData() method reads the override setting and looks for the remote database from the registry. It doesn't check to see if the remote view is in the default database. This behavior is somewhat desirable, but it means that you cannot have local and remote data in the same database unless you set your preferences to point the exact same location. The other alternative is to have multiple databases. (Use MetaData Database Manager.) I would rather not do this because some rewritting is involved. If anyone has any suggestions, let me know.