Viewing the underlying data – PB Docs 2018
Viewing the underlying data If you want users to be able to see the raw data as well as the cross-tabulated data, you can do one of two things: Place two DataWindow controls on the window or form: one that is associated with the crosstab and one that is associated with a DataWindow object that…
Modifying the crosstab’s properties during execution – PB Docs 2018
Modifying the crosstab’s properties during execution As with other DataWindow objects, you can modify the properties of a crosstab during execution using the Modify method. Some changes require the DataWindow control to dynamically rebuild the crosstab; others do not. (If the original crosstab was static, it becomes a dynamic crosstab when it is rebuilt.) Changes…
How query mode works – PB Docs 2018
How query mode works Once the DataWindow is in query mode, users can specify selection criteria using query by example — just as you do when you use Quick Select to define a data source. When criteria have been defined, they are added to the WHERE clause of the SELECT statement the next time data…
Supported versions for SQL Anywhere – PB Docs 2018
Supported versions for SQL Anywhere The SQL Anywhere ODBC driver supports connection to local and remote databases created with the following: PowerBuilder running on your computer SQL Anywhere version 17.x SQL Anywhere version 16.x SQL Anywhere version 12.x Document get from Powerbuilder help Thank you for watching.
Understanding Data Connections – PB Docs 2018
Understanding Data Connections Contents How to find the information you need Accessing data in PowerBuilder Accessing the Demo Database Using database profiles What to do next About this chapter This chapter gives an overview of the concepts and procedures for connecting to a database in the PowerBuilder development environment. Document get from Powerbuilder help Thank you…
Saving the template – PB Docs 2018
Saving the template To save a new default template, select Save from the pop-up menu in the Export Template view for XHTML, name the template, and provide a comment that identifies its use. The template is stored inside the DataWindow object in the PBL. After saving a template with a DataWindow object, you can see…
What are Open Client directory services? – PB Docs 2018
What are Open Client directory services? Open Client 11.1.x or later directory services allow you to use a supported third-party directory services product (such as the Windows Registry) as your directory service provider. Directory services provide centralized control and administration of the network entities (such as users, servers, and printers) in your environment. Document get from…
Getting detailed information about the class – PB Docs 2018
Getting detailed information about the class This section has code fragments illustrating how to get information from a ClassDefinition object called cd_windef. For examples of assigning a value to cd_windef, see Getting a class definition object. Library The LibraryName property reports the name of the library a class has been loaded from:
|
1 |
s = cd_windef.LibraryName |
Ancestor The…
AddLocalRef – PB Docs 2018
AddLocalRef Description Adds a local reference to the specified PowerBuilder object. Syntax
|
1 |
AddLocalRef (pbobject obj) |
Argument Description obj A valid PowerBuilder object handle Return value pbclass or null on error. Examples This example defines functions that add and remove local references:
|
1 2 3 4 5 6 7 8 9 10 |
void MyPBNIClass::reference() { d_session->AddLocalRef(d_pbobject); } void MyPBNIClass::unreference() { if(d_pbobject != NULL) d_session->RemoveLocalRef(d_pbobject); } |
See also PopLocalFrame PushLocalFrame RemoveLocalRef Document get from Powerbuilder help Thank you for watching.
Example 1 (using RESTClient) – PB Docs 2018
Example 1 (using RESTClient) If the JSON string returned from the RESTFul Web Service perfectly meets the requirements specified in the section called “JSON formats (required by RESTClient object)” in PowerScript Reference, you can directly use the RESTClient object to get the data, as shown below.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
restclient lnv_restclient string ls_url long ll_row lnv_restclient = create restclient ls_url = "https://rest.appeon.test/getemployees" /* JSON string retruned from the url [ {"Id":1106,"First_name":"Vincent","Last_name":"Phillipino","Sex":"Male","Age":63}, {"Id":1107,"First_name":"Natalie","Last_name":"Mariano","Sex":"Female","Age":16}, {"Id":1108,"First_name":"Li","Last_name":"Mary","Sex":"Female","Age":36}, {"Id":1109,"First_name":"Vic","Last_name":"Lu","Sex":"male","Age":20} ]*/ ll_row = lnv_restclient.retrieve(dw_1,ls_url) destroy lnv_restclient messagebox("Restclient","The rowcount of dw_1 = "+string(ll_row)) |
Document get from Powerbuilder help Thank you for…