Specify the Web API URL – PB Docs 2022
Specify the Web API URL For the installable cloud application to run successfully, you need to tell the client app where the Web APIs is hosted and run. In the Deploy > Basic tab, you can specify the Web API site URL for the application. To deploy to the local Kestrel server, the site URL…
MaximumValue – PB Docs 2022
MaximumValue property for PowerScript controls Applies to grAxis objects in Graph controls Description The MaximumValue property specifies the maximum value for an axis when the axis datatype is numeric. This property is not used if the Autoscale property is enabled. Usage In a painter To set the maximum value of an axis with a numeric…
Start session manually by code – PB Docs 2022
Start session manually by code By default, the user session is automatically created when the application starts; and the session includes no token. For the session to include the token, the session must be started manually by code instead of automatically. To start the session manually by code, Step 1: Select the “Dynamic session parameters”…
MD5 – PB Docs 2022
MD5 PowerScript function Description Calculates the MD5 value of a blob. Applies to CrypterObject object Syntax
|
1 |
crypter.MD5 (variable) |
Argument Description crypter The name of the CrypterObject object variable A blob whose value is the data you want to process with MD5. When using the system blob function to convert a string to a blob, it is…
LoadFailedTransactionsStatistics – PB Docs 2022
LoadFailedTransactionsStatistics Loads the detailed statistics of failed transactions. Syntax: GET /api/Statistics/LoadFailedTransactionsStatistics PowerScript code example:
|
1 2 3 4 5 6 7 8 9 10 11 |
Integer li_rc String ls_body httpclient lhc_client lhc_client = create httpclient lhc_client.setrequestheader("Content-Type", "application/json;charset=UTF-8",true) li_rc = lhc_client.sendrequest( "Get", "http://172.25.100.32:5000/api/Statistics/LoadFailedTransactionsStatistics") if li_rc = 1 and lhc_client.getresponsestatuscode( ) = 200 then lhc_client.getrequestbody(ls_body) end if |
When successful, it returns the response status code 200 and the following response body: When failed, it returns 400 (bad request), 401 (unauthorized), or 500 (server error).
|
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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
[ { "createdTime": "2022-02-21T02:35:59.790Z", "startedTime": "2022-02-21T02:35:59.790Z", "executionTime": { "ticks": 0, "days": 0, "hours": 0, "milliseconds": 0, "minutes": 0, "seconds": 0, "totalDays": 0, "totalHours": 0, "totalMilliseconds": 0, "totalMinutes": 0, "totalSeconds": 0 }, "transactionId": "string", "transactionStatus": 0, "requestsStatistics": [ { "executionStart": "2022-02-21T02:35:59.790Z", "executionTime": { "ticks": 0, "days": 0, "hours": 0, "milliseconds": 0, "minutes": 0, "seconds": 0, "totalDays": 0, "totalHours": 0, "totalMilliseconds": 0, "totalMinutes": 0, "totalSeconds": 0 }, "isSuccess": true, "transactionId": {}, "dbRequestKind": 0, "requestDataFormat": 0, "moduleOrModelName": "string", "sqlId": "string", "sqlStatement": "string", "sqlParameters": [ "string" ], "columnCount": 0, "rowCount": 0, "hasResultSet": true, "resultLength": 0, "sqlDbCode": 0, "errorMessage": "string" } ] } ] |
Document get from Powerbuilder help Thank you for watching.
MaskPassword – PB Docs 2022
MaskPassword database parameter Description Specifies whether you want PowerBuilder to mask your password automatically when connecting to an OLE DB data provider. When to specify MaskPassword You must specify the MaskPassword parameter before connecting to the database. Applies to OLE DB Syntax
|
1 |
MaskPassword='value' |
Parameter Description value Specifies whether you want PowerBuilder to mask your password….
SyntaxFromSQL execution error – PB Docs 2022
SyntaxFromSQL execution error The application crashes when executing the same SQL statement via SyntaxFromSQL. Debugging technique: We shall first check the web debugging proxy tool, such as Fiddler, to locate at what operation the error occurred (at the execution of SyntaxFromSQL), and also find out the error message captured. Check in the Inspector TextView for…
LoadWithDotNetCore – PB Docs 2022
LoadWithDotNetCore PowerScript function Description Loads a .NET Core assembly. Note In PowerBuilder 2022 R2 and later, you should upgrade your .NET Core assembly to .NET 6.0 assembly and use the LoadWithDotNet function instead. PowerBuilder 2022 R2 and later supports .NET only (.NET Framework and .NET Core have been removed since Version 2022 R2). Applies to…
Unsupported features that can be detected – PB Docs 2022
Unsupported features that can be detected Contents SetTrans Data pipeline MobiLink Oracle RPC arrays SQLPreview SQLReturnData property Transaction trace Retrieve As Needed and Rows to Disk Commit or Rollback Transaction using Dynamic SQL Data retrieval in the RetrieveRow event This section lists the unsupported features that can be detected by the deployment tool, and provides…
ListViewItem object – PB Docs 2022
ListViewItem object A ListViewItem object is a system structure that populates a ListView control. ListViewItems have no events. Properties ListViewItem property Datatype Description ClassDefinition PowerObject An object of type PowerObject containing information about the class definition of the object or control. CutHighlighted Boolean Specifies whether the item is the target of a cut operation. Values…