Set the Connection Information for the OData Service
As with other databases, use the SQLCA Transaction object (or user-defined
transaction object) to retrieve and display data from the OData service in a DataWindow or
DataStore.
- Set the appropriate values for the transaction object.
- Connect to the OData service.
- Set the transaction object for the DataWindow or DataStore.
- Retrieve and update the data.
- When the processes are complete, disconnect from the OData service.
The code looks something like
this:
this:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SQLCA.DBMS = "ODT" SQLCA.DBParm = "ConnectString='URI=http://esx2-appserver/TestDataService/Employee.svc'" //connect to the service connect using SQLCA; dw_1.SetTransObject(SQLCA) dw_1.Retrieve() ... //disconnect from the service disconnect using SQLCA; |
For
more information on using the global Transaction object, see Application
Techniques.
Parent topic: OData Support
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest