CreateFrom
method (DataWindows)
Description
Creates a DataStore object from the passed ResultSet object.
Applies to
|
DataWindow type |
Method applies to |
|---|---|
|
PowerBuilder |
DataStore object |
Syntax
PowerBuilder
|
1 |
integer dsobject.CreateFrom ( ResultSet rssource ) |
|
Argument |
Description |
|---|---|
|
dsobject |
The name of the DataStore object into which you want |
|
rssource |
A ResultSet or ADOResultSet object that contains meta |
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
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.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
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