OI table mirror of dataset table (datasets) (OpenInsight Specific)
At 07 MAY 1999 12:44:02PM John Poremba wrote:
I need to read data from foxpro/datasets and combine this data with existing OI applications and data.
I have created connections, datasets, forms and popups. However I have problems getting the results I require. In part to lack of serious documention (ie: examples) in both the Application development and programers manuals. I admit to lack of OI expericence and most of these applications were developed in Arev 2.1 and converted to OI. I'm still in a learning curve.
In an effort to speed development up and start using (deadline date) a specific application I'm willing to copy (daily), data from the foxpro dataset to a mirror OI table. Is there a proceedure or subroutine available to use or modify to accomplish this task?
Any help/advice would be apprecated.
Note to Revelation Software:
The connection/dataset feature combined with LH tables is an outstanding combo. It seems to me use of this feature should be better defined/documented/promoted, after all it's a development tool and selling feature. Accessing and using non-LH tables is not a bad thing.John Poremba
Information Systems Mgr.
E-Z DO, Inc.
732.287.6940
At 11 MAY 1999 04:30PM Cameron Revelation wrote:
I'm willing to copy (daily), data from the foxpro dataset to a mirror OI table.
You can start with the example code in the help file. Go to the System Editor, create a new proc, type "qrymethod", highlight it, and press F1.
As far as combining data on a form (for example) it is pretty simple but there are a few tips that help. We've tested internally with a single form containing data from Notes, SQL databases, and LH. I would suggest getting a form to work with just your Fox data and then expanding from there. Let me know what part you are getting stuck on and we can point you to information here or elsewhere that will help out.
Cameron Purdy
Revelation Software