To select the OData Service datasource in the DataWindow wizard:
-
Select File > New from the menu bar and select DataWindow.
-
If there is more than one target, select the target where you want the DataWindow to be created from the drop-down list.
-
Choose the presentation style for the DataWindow object and click Next.
-
Select the OData Service datasource and click Next.
-
Select the OData profile and click Next.
-
In the SQL painter.
-
You can select one table.
-
The Sort, Group, and Having tabs are not available.
-
The Results tab is obsolete, because it is used by PowerBuilder .NET.
-
In the Where tab you can specify some selection criteria using the WHERE clause for the SELECT statement.
When you complete the query, click OK.
-
-
Review your specifications and click Finish.
At runtime, the DataWindow or DataStore can manipulate OData service data, which includes retrieving, updating, inserting, and deleting the data.
