Discussions tagged PowerBuilder (Appeon)
Re: DW with PostgreSQL - Crosstab with Retrieval argument
- New
- Issue
- Last updated 5 days ago
- Olan Knight replied 3 days ago
Hello,
PB 2019R3 - PostgreSQL 11
Sample Query to construct a datawindow. Actual query is bit length and does more
SELECT *
FROM crosstab(
$$SELECT *
FROM example
Where field1 = '100'
And field2 = '200'
ORDER BY...
PB 2022 connectivity error with SQLOLEDB
- Resolved
- New
- How-to
- Last updated 6 days ago
- Roland Smith replied 5 days ago
Hi Experts,
******************************************************************
Database Versions: Microsoft SQL Server 2014/Microsoft SQL Server 2019
******************************************************************
I have upgraded my existing ...
Column contents splits between pages in Detail section when too long. Pb12_5 and PB2019
- New
- Issue
- Last updated 1 week ago
- Olan Knight replied 6 days ago
Hi,
I have a problem with a datawindow field when its length exceeds the height of the page. The field can be up to 4000 characters long. When exposed in the datawindow, it happens that the text is truncated and carried over to the next page. The fi...
Passing numeric arguments by readonly
- Resolved
- Advice
- Last updated 1 week ago
- John Fauss replied 1 week ago
Hello Appeon Community,
According to article from https://docs.appeon.com/pb2019/pbug/ch07s02.html#ug12761:
Read-only. When you pass as read-only, the variable's value is available to the function but it is treated as a constant. Read-only provi...
To change Background color of DDLB inside a datawindow
- How-to
- Last updated 1 week ago
- Chris Pollach @Appeon replied 1 week ago
Hello,
PB 2022 B 1892, No theme
Need to set background color of a DDLB, which is inside a datawindow column. By default, it's white and I could not find any way to change it in the properties panel (or I'm missing?).
Any modify command can do...
Powerbuilder 2022 build 1892/ Windows 10
GIT central repository : Azure Devops (If it matters )
I get the message
" ---------- Source Control: Errors (17:39:52)Git detail error info: The path 'C:' does not exist in the given treeGit client error...
InkPicture control works in my computer but does not work in the server
- Resolved
- Issue
- Last updated 1 week ago
- Alex Hernandez replied 1 week ago
Hello,
I've added an InkPicture control to a window where I load a blob image from the database (with LoadPicture function), using Powerbuilder 2019 R3. It works perfectly in my computer. But when I deploy the PBD file in the server where the users ...
Do you have OPEN AI ( ChatGPT API library PBL)? I'm trying to test it with the source code below, but it says there is no supported library.
- Below -
string ls_api_key, ls_question, ls_answern_cst_openai_api n_apiwindow w_question
// 테이블 생성 (만약 T...
Migration of Datawindow if database scheme changed
- Resolved
- How-to
- Last updated 2 weeks ago
- Andreas Mykonios replied 2 weeks ago
Hi,
are there any possibilites to migrate datawindows automatically to a new database scheme, if the length of some fields have changed?
Actually i have to edit each datawindow and change the length of the database manually....
We use the ASE Data...
Read some dw in a timer event window
- How-to
- Last updated 3 weeks ago
- Miguel Leeuwe replied 3 weeks ago
Hi guys.There is a way to read several dw at the same time in timer's event window?. Each dw have different number of records (different data); so each dw must read regardless of what the others do.
Is there a way to do it?When a record is read, i...
Persistent app crash caused by string parsing in subroutine.
- Resolved
- Issue
- Last updated 3 weeks ago
- kevin kevin rowe replied 3 weeks ago
i have a code module that was working fine,
I have had to add a section of code to it to place a database field of (up to) 1000 characters in 4 dot matrix report fields of flat 70 characters.
To do this I created a subroutine that would read the fi...
Has anybody accessed Stripe directly from PB? Currently we are doing all of our Stripe access via Java services on our server, called from PB, which use the Stripe Java API. But it would be nice to be able to do some simple things directly from PB, e...
Insert Row - Datawindowchild Retrieval Arguments
- Resolved
- How-to
- Last updated 3 weeks ago
- Sivaprakash BKR replied 2 weeks ago
Hi all,
I am wondering if anyone can help with this? I currently have a report datawindow inside a parent datawindow. I am running into an issue where inserting a row into the Parent Datawindow causes the child to ask for retrieval arguments. Is the...
How do I communicate between a pop-up window and parent window?
- Resolved
- How-to
- Last updated 1 month ago
- Tracy Lamb replied 3 weeks ago
Hi all,
I have a window with a tab folder. The tab folder has 4 tabs. In one of the tabs, I need to open a pop-up window from the dw on the tab page to do some calculations. (The window pops up from an option on the RMB menu). The dw has a couple...
SQL select from PowerBuilder returns only part of data
- Issue
- Last updated 1 month ago
- Chris Pollach @Appeon replied 1 month ago
Hi, Using PowerBuilder 2019 R3 build 2703 with SQL Server version ? ( I know it is new. 'SELECT @@version' returns Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 12 2023 05:25:39 Copyright (C) 2022 Microsoft Corporation )
DBMS=ODBC
DBParm=Conne...
PB DW Report - Summary nested report not displaying all data
- Resolved
- Advice
- Last updated 1 month ago
- John Fauss replied 3 weeks ago
Hi Team,
Not sure if this is a known issue, i have noticed that the nested report that i have placed in my Datawindow summary section is not displaying all the data retrieved by the report and is truncating after a few rows (I have attached a screen...
Password encryption using Salt and Hashing in PB2019R3
- Resolved
- How-to
- Last updated 1 month ago
- Ganesan Rajan replied 1 month ago
Hi,
Our application is based on PB2019R.
To login to our application, the user has to enter a password. Currently we are using own way of encrypting password and storing it in table.
BUT, we have been asked to use "Salt and Hash" to encrypt our ap...
Hi
Is there a way how to get list of stack calls into a variable, message or another object?
Like Java can do it in exception.
What's going on:
In my SW I'm catching systemerror, datawindow errors etc and I'm sending these errors through mails. I...
how to click from one sle to another?
- Resolved
- How-to
- Last updated 1 month ago
- Tracy Lamb replied 1 month ago
Hi all,
I've got a child window that does a lot calculations depending on what's entered. All sle's have tab orders and code for the GetFocus and Modified events. I can't click in a sle to edit the value, the only way to move to another sle is by ta...
How can I open a PDF document in Acrobat or other pdf reader?
- Resolved
- How-to
- Last updated 1 month ago
- Tracy Lamb replied 1 month ago
Hi all,
I've added the ability to "attach" pdf documents in several places in my app. I also added "view" capability, that opens the pdf in a web browser. One of my customers wants to "open" the pdf in Acrobat (or other pdf app) to make some edits...
- Page :
- 1