Discussions tagged PowerBuilder (Appeon)
I migrated our client's application from PowerBuilder 2017 32-bit to PowerBuilder 2022 64-bit, the below code are under Local External Functions declaration in a user object, the below code can successfully run in PowerBuilder 2017 32-bit, but after ...
Offline License, How to Get?
- New
- Misc
- Last updated 2 days ago
- Armeen Mazda @Appeon replied 2 days ago
I may be developing inside an AWS sandbox environment which probably won't have it's own internet access. How do we get an Offline Licence for PB 2022?
Thanks
Matt...
Our DBA team tested Oracle’s Transparent Application Continuity (TAC) which allows a live switch of the database from one server to another without losing the Oracle connections to the database. When the test was performed against our PowerBuilder a...
Find columns in my app that are set to enable autocomplete
- Resolved
- New
- Advice
- Last updated 4 days ago
- Tracy Lamb replied 3 days ago
Hi all,
I changed a lot of my drop-down lists to autocomplete style before I realized the implications of setting the column to allow edits. Is there a way in PB to find all columns set for autocomplete (autocomplete not equal to 0)? Or maybe all ...
Copy CLIB windows to new powerbuilder instal
- New
- How-to
- Last updated 5 days ago
- René Ullrich replied 5 days ago
Hi
Just installes PB on a new mashine.
How can I copy my scripts in the 'CLIB' window in PB from one maschine to an other, without copying every single script...
Change background.transparency in nested report object - PB2022 R3
- How-to
- Last updated 1 week ago
- Mark Goldsmith replied 1 week ago
I have been tasked with adding a watermark to printed documents.
Before printing, I copy the dataobject into a local datastore, copy the data (RowsCopy), add the watermark to the background (Modify("CREATE...")), and then make the background for ea...
RestClient caused application to hang
- Issue
- Last updated 1 week ago
- Chris Pollach @Appeon replied 3 days ago
Hi! We're deploying PB 2022 Build 1892. I came across a situation yesterday that confuses me. Here's the code:
lrc_rest = create RESTClient
lrc_rest.SecureProtocol = SECURE_PROTOCOL_TLS1_2
lrc_rest.Timeout = 10
ls_get = 'XMLData=<root>&...
PB PFC column header sort and issues with Grid presentation datawindow.
- Resolved
- How-to
- Last updated 1 week ago
- Ronnie Po replied 1 week ago
Issue: After PFC sorting on clicking the header of the results set (datawindow) the suppress repeating values does not work and displays the suppressed values again giving an appearance of duplicate values.
PowerBuilder Version 2022 R3 → Build 3289
...
I have a radiobutton style column in a DW (PB 2021) that normally has 3 options. However, depending on some situations I need to change it to only 2 or only 1 option, with varying text. To set it to only 1, I use code like:
dw.object.columnName.valu...
Why SetSqlSelect returns -1 with SQLite connection
- Issue
- Last updated 2 weeks ago
- Sivaprakash BKR replied 2 weeks ago
Hello,
Using PB 2022 R3 Build 3289 (64 bit) with PostgreSQL 15 and SQLite 3
We have many reports which constructs required SQL and set it with SetSQLSelect to retrieve the data. It works perfectly fine when we connect to PostGreSQL 15. And fails ...
Hello,
We are currently using third party solutions to use some of our PowerBuilder apps as a service in Windows.
However, we are in the middle of a Windows Server 2012 to Windows Server 2022 migration and we struggle to get one them running ok.
T...
PowerBuilder App 2019 Sometimes Crashes When Running From 2022
- Issue
- Last updated 2 weeks ago
- Kevin Ridley replied 2 weeks ago
I have a PowerBuilder app runs fine in production when compiled with 2019. We are trying to move to 2022 but that app starts but after hitting a button in one of the windows it crashes. We can resolve this by regenerating one of the objects. After...
Restriction in HTTP.SendRequest
- Resolved
- Issue
- Last updated 2 weeks ago
- Arthur Hefti replied 2 weeks ago
Hello,
Using PB 2022 R3 b 3289, HTTPClient
Trying to send multi-part data.
1. Working fine in Windows 102. Not working in Windows 7 - Returns li_ret = -193. Not working in Windows Server 2012 R2 - Returns li_ret = -4
C...
Best Driver to connect to SQL Server 2019/2022
- How-to
- Last updated 2 weeks ago
- Andreas Mykonios replied 2 weeks ago
Hi there,Currently we use ODBC to connect to SQL Server 2019/2022, but we want the best possible performance and as such we're looking for the best practice in this regard.
We're using Powerbuilder Version 2022, Build 1878.
Thank you in advance for...
Equivalent of Postman's Form-data in PB's HTTPClient
- Resolved
- How-to
- Last updated 2 weeks ago
- Sivaprakash BKR replied 2 weeks ago
Hello,
Using PB 2022 R3
Need to a call API which sends a file along with other parameters. It could be successfully sent from Postman using form-data, where there is an option to enter text or select a file option.
Now need to send the same us...
How to pass key value pair in Powerbuilder
- Resolved
- How-to
- Last updated 3 weeks ago
- Sivaprakash BKR replied 2 weeks ago
Hello,
Using PB 2022 R3
Need to call an API, parameter in key-value pair. How to pass the same in Powerbuilder?
<?php
$create = [
"secret" => "API_SECRET", // your API secret from (Tools -> API Keys) page
];
$cURL = ...
How to disable the theme for datawindow when the theme is applied
- How-to
- Last updated 3 weeks ago
- kitty he @Appeon replied 2 weeks ago
Hi All,
I have applied the theme for the application using PowerBuilder 2022 R3 Build 3305.
I have two user objects. In one object, I am able to disable the theme for the data window (tp_grid), but in the other, I am not able to disable the theme(t...
Adding alias to column gives ORA- 00920 when using query mode with Oracle
- Issue
- Last updated 3 weeks ago
- Chris Pollach @Appeon replied 3 weeks ago
When querying using query mode when connected to Oracle 19c, and the column being queried has an alias, the oracle statement looks like this.
(AND table.column aliase = 'Input data' )
Example:
In the select part:
COMPANY.STATUS COMPANY_STATUS
P...
Hello,
Just went through this article again.
https://community.appeon.com/index.php/blogs/recent-blogs/the-future-of-powerscript-desktop-apps
It's been 5 years since this article was published. Can we discuss again what has been accomplished and ...
REST API and OAuth on older version of PowerBuilder
- How-to
- Last updated 1 month ago
- Chris Pollach @Appeon replied 1 month ago
Hi,
I have an old client who used the application developed using PowerBuilder 7 really long ago.
The client current use this for back up and now rarely use this system, but they recently requested asking if it's possible to do do some enhancement...
- Page :
- 1