Discussions tagged PowerScript (PS)
Hi All,
I am using PowerBuilder 2022 R3 Build 3356 and MS SQL Server 2019 with the collation set to Latin1_General_100_CI_AI_SC_UTF8.
In a DataWindow, I have a column of type string with a length of 375. I have limited the users to type up to 375 c...
Hi all, is there an event that fires on the entire window where I can maybe check if the user clicked on a window object?I'm trying to create a program where the user has to click on an object in a window to select it and send information about that ...
PrintDataWindow Issue in 2022R3 64-bit
- Resolved
- Issue
- Last updated 3 months ago
- Roland Smith replied 3 months ago
We have encountered an issue with our recent migration over to 2022R3 64-bit when printing datawindows using the PrintDataWindow/PrintOpen calls.
The window will freeze, and does not print:
We are also unable to cancel the print job.
...
HI All,
I need help. I have a structure, `str_patient`, with different data types such as long, string, boolean, datetime, datawindow, and userobject. From one datawindow, I am loading the local structure with all required parameters and the datawin...
The match function returns the wrong value
- Resolved
- How-to
- Last updated 7 months ago
- Benjamin Gaesslein replied 7 months ago
Hi all.I'm using the match function to match a string that doesn't contain lowercase letters, but I'm getting an error with the following code example
if match("abc", "^.*[^a-z]+.*$") then
messagebox("", "match")
end if
I checked the document...
No "Invalid DW row/column specified" error for row 0
- Issue
- Last updated 8 months ago
- Chris Pollach @Appeon replied 7 months ago
Hello,
I started noticing quite some time ago (maybe in PB 12.5, maybe earlier) that PB stopped throwing an error when GetItemX datawindow method is called with row 0. Now, when it happened again in PB2019 R3, I decided to isolate the issue. I creat...
Interesting PowerScript behaviour
- Misc
- Last updated 8 months ago
- Andreas Mykonios replied 8 months ago
Hello,
I've stumbled upon this phenomenon while writing tests with PBUnit. For illustration purposes, I isolated it as follows.
Create two global functions:
global function integer f_set_string (integer ai_in, ref string as_out);
if ai_in = 1 the...
Is there any specific issue with "OAuthClient" and "TokenRequest" object and the grant_type as "Autherization_code" for access token request? Is there any security concern or disadvantage of using "HttpClient" object for requesting the access token instead of "OAuthClient" and "TokenRequest" object?
- Issue
- Last updated 11 months ago
- Namdev Gopalghare replied 11 months ago
We are trying to implement the OAuth flow in PowerBuilder windows application using Azure AD.
When the access token is requested using the "OAuthClient" and "TokenRequest" object with the grant_type as "Autherization_code" then we are always getting...
Powerser Deployment to Ubuntu 22.04
- Resolved
- How-to
- Last updated 11 months ago
- Narayana Bhat P replied 9 months ago
Hi Team,
We have succesfully buuild our application in powerserver and able to convert and access through browser in localhost.
Now we are trying to deploy application in ubuntun 22.04
We are using below version of powerbuilder and powerserver
...
Hello all,
I have a problem.
I am using Powebuilder 2022 R2. I have a c# class that needs to call a powerscript. The video I came across showed us to do it through Powerbuilder.RegisterObject, PowerBuilder.RegisteredObject.TriggerEvent and .Net Dll...
Hello All
We are migrating to 64 bits enviroment (PB2022 R2)
we have a external file in dbf format
in 32 bits we are using the microsoft driver for dbf but it is only available in 32 bits
does anyone have manage to connect to a DBF file in 64 bi...
Powerbuilder Classic window 100% transparent background with static text 100% visible
- Resolved
- How-to
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
I have made a Powerbuilder classic window with a transparent background which works almost perfectly for the task I'm trying to achieve. I'm trying to have a transparent window topmost over all other applications (achieved that part so far), which ha...
Listview Items to String Format
- Resolved
- How-to
- Last updated 1 year ago
- John Raghanti replied 1 year ago
Good day!
I need help in my code in which I have this listview as shown below
What I want to achieve is that I want to go over each value of the listview and have the result to be formatted as:
"a_1,a_10,a_2,a_3,a_4,a_5,a_6,a_7,a_8,a_9"
So far ...
Using ChatGPT to generate PB Code
- Resolved
- Misc
- Last updated 1 year ago
- Denis Proctor replied 1 month ago
For what it's worth, I've asked ChatGPT to write PowerBuilder code for a few relatively simple functions. The results were good, often giving me better ways to approach a problem. Amazing stuff this AI....
How to convert unicode string into corresponding characters
- Resolved
- How-to
- Last updated 1 year ago
- Benjamin Gaesslein replied 1 year ago
Hello everyone
I now have a a.txt file, the content is \u5171\u7528, after using the fileread() function to read, I want to convert \uxxxx into corresponding characters, the following is my attempt
li_fhandl=fileopen("C:\work\a.txt")
li_fread=file...
What function can be used to import window into pbl
- Resolved
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hello everyone!
I use the LibraryExport function to export all the objects in pbl. When I want to use the LibraryImport function to import, I see in the document that the LibraryImport function can only import the DataWindow type. Why is this ?
Are...
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 get a modern version of GetFolder()
- How-to
- Last updated 1 year ago
- Roland Smith replied 1 year ago
Hi,
How can I get a modern windows 10/11 version of the getfolder dialog box and not the one from 1999 :-)
Thanks Steen...
Convert decimal to invariant string
- How-to
- Last updated 2 years ago
- Benjamin Gaesslein replied 1 year ago
Hi
Is there a direct way how to convert a decimal to a culture invariant string?
Standard method string( decimal ) returns the string converted according to the local user's setting. Like in Europe string(1.2) returns "1,2". Or "1'2" etc. What I wa...
Getting proper NUP row # during pbm_dwnmousemove event
- Issue
- Last updated 2 years ago
- Frank Zettanucci replied 2 years ago
I have built a NUP 7 Datawindow SQL Server Select with a TOP 42 custom select statement to always return only 42 results.
At first, I removed all of the columns on the freeform styled NUP and added 7 computed items each with a custom BITMAP call to ...
- Page :
- 1