Description
Creates a DataStore object from the passed ResultSet object.
Applies to
Syntax
PowerBuilder
integer dsobject.CreateFrom ( ResultSet rssource )
|
Argument |
Description |
|---|---|
|
dsobject |
The name of the DataStore object into which you want to place the data in the passed result set |
|
rssource |
A ResultSet or ADOResultSet object that contains meta data from which the DataStore object is created |
Return value
Integer. Returns 1 if it succeeds or a negative number if an error occurs. If any argument is null, in PowerBuilder the method returns null.
Usage
Use CreateFrom to create a DataStore from a passed result set. Typically, a PowerBuilder client calls methods on a component running in a transaction server and converts results sets returned from those methods to DataStore objects using CreateFrom.
CreateFrom creates an external DataWindow definition with no visual component -- it has no controls and the height of all bands is zero. Since the data source for the DataStore object is external, Update methods on the DataStore object have no effect. The Print method will print a blank page.
Client applications can use the DataStore object directly or display the data in a DataWindow control using the ShareData method.
For more information about result sets and methods for exchanging data between components and clients, see Usage for GenerateResultSet.
Examples
This example creates an instance of the SVUBookstore component, calls the GetMajors method, and creates a DataStore object using the data definition in the returned ResultSet object:
SVUBookstore lcst_mybookstore
resultset lrs_resultset
datastore ds_local
integer li_rc
li_rc = myconnect.CreateInstance(lcst_mybookstore)
IF li_rc <> 0 THEN
MessageBox("Create Instance", string(li_rc) )
myconnect.DisConnectServer()
RETURN
END IF
lrs_resultset = lcst_mybookstore.GetMajors()
ds_local = CREATE DataStore
ds_local.CreateFrom(lrs_resultset)This example creates a DataStore object from an ADO Recordset returned from a method on an MTS component.
OLEObject loo_mycomponent
OLEObject loo_ADOrecordset
ADOresultset lrs_ADOresultset
datastore ds_local
integer li_rc
loo_mycomponent = CREATE OLEObject
li_rc = loo_mycomponent.ConnectToNewObject("PB.Test")
IF li_rc <> 0 THEN
MessageBox("Connect Failed", string(li_rc) )
RETURN
END IF
// Use an OLEObject to hold ADO Recordset
// returned from method on MTS component
loo_ADOrecordset = loo_mycomponent.GetTestResult()
// Create an ADOResultSet and get its data
// from OLEObject holding passed ADO Recordset
lrs_ADOresultset = CREATE ADOResultSet
lrs_ADOresultset.SetRecordSet(loo_ADOrecordset)
// Use CreateFrom to populate DataStore
// from ADOResultSet object
ds_local = CREATE DataStore
ds_local.CreateFrom(lrs_ADOresultset)See also
SetRecordSet in the section called “SetRecordSet” in PowerScript Reference
SetResultSet in the section called “SetResultSet” in PowerScript Reference
