inline warehousing (OpenInsight Specific)
At 17 FEB 2000 01:17:22PM S. Berger wrote:
I have some data that I am trying to export some report data into an access database. I have two theories about how I can do this.
The first, place the report into a lh table and run a CS/warehouse procedure against the data. If I do this the question is, how do I dynamically launch the warehouse procedure from a basic+ script? What does the call look like?
The second, and prefered, method would be to bypass the lh table and write the data directly into the access. It seems to me that this should be possible. The only difference from the warehouse is that we are passing the data directly instead of reading the table. The question, how? I have been looking at the WP_ procedures and I can quite figure out how to do this?
Any ideas?
S
At 17 FEB 2000 01:59PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
This is indeed possible using datasets and connection objects. A comprehensive introduction for new users can be found in this SENL back issue.
World Leaders in all things RevSoft
At 21 FEB 2000 07:10PM S. Berger wrote:
Insert scream of profound anguish here.
First off, thanks for the response. After reading SENL Volume 2 Issue 3, the scripts generated by the warehouse manager, and numerous other posts on this BBS, I have developed the following script.
hXO =XOInstance("OIBITS","ODBC","","","","","")
hDS =DSInstance("DS_MASTERACCRUAL", hXO)
ok =DSMethod(hDS, DS_EXECUTE$)
result=DSSetProperty(hDS, DS_ARG$, MEDRECNO)
result=DSSetProperty(hDS, DS_WORK_ROW$, record)
result=DSMethod(hDS, DS_APPEND_WORK$)
ok =DSMethod(hDS, DS_EXECUTE$)
It appears like everything is working except for the DS_EXECUTE$ statements. I?m not even sure that I need the executes. I am not getting any data in the access database. I am able to drop and create the tables so I know that the connection abject is working.