Discussions tagged Function
What is the algorithm for the Round function?
- Resolved
- How-to
- Last updated 5 months ago
- Tracy Lamb replied 5 months ago
Hi all,
I'm using the Round() function to round numbers. It seems to be inconsistent, but I may be misunderstanding what's going on.
I am rounding 20 +/- 0.85. When I round to 2 digits I get:
19.15 and 20.85
When I round to 1 digit I get:
19...
Match non-numeric characters
- Resolved
- How-to
- Last updated 5 months ago
- Miguel Leeuwe replied 5 months ago
Wondering how to write the match clause so it finds the first non-numeric value. This algorithm is finding the first a-z character, but if the first non-numeric character is a special character, it doesn't work.
for li_x = 1 to li_length
ls_char ...
window function - missing fields to allow setting return etc
- Resolved
- How-to
- Last updated 6 months ago
- Andrew Davis replied 6 months ago
Hi all
PB2023r3 Windows 10
I am sure this is an easy one - but i cant find it !
When i add or edit a window function - the screen does not show the section that allows you to enter the return type or the function name
I tried reseting the layou...
INFOMAKER Grouping same articles (with Diff. Serial Numbers) on a single line
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hi there,
I would like to group the same articles on a single line on our invoices...
As a matter of fact, these articles are managed with serial numbers (there is consequently a line per Serial Number in the datasource)
Of course, each Item has t...
Passing numeric arguments by readonly
- Resolved
- Advice
- Last updated 1 year ago
- John Fauss replied 1 year 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...
Reference string variables truncated when passed back from stored procedure
- Issue
- Last updated 3 years ago
- Karen Gray replied 3 years ago
HI,
We are using PB 2017 R3 against a postgres database. We are in the process of porting our application from informix to postgres database.
I have an issue in that functions declared with reference variables - after retrieving the data - the s...
Replace spaces with %20 so I can view link in browser
- Resolved
- How-to
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
Hi all,
I'm having trouble viewing documents in my browser if the document name has any spaces. I'm trying to replace spaces with %20 for the browser... but when I run my code, it replaces space with %2520 ... here's an example:
file:///E:/BenchTo...
PB2019 R3 2703 - Paste function
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
Hi,
I've come across a problem when using the Paste command.
The Paste actually works fine, but the return code is -1.
To recreate:
Sample window, RichText control, CB with paste function to the RT control.
Copy an image from Snipping Tool.
Pas...
Custom Function - Return pbl name, datawindow name, last modified
- How-to
- Last updated 3 years ago
- John Fauss replied 3 years ago
is there any existing function or functions that will return the current data window name, the pbl and the last modified date of the data window ? ...
Error using DataStore into user function
- Resolved
- Issue
- Last updated 3 years ago
- John Fauss replied 3 years ago
Hi,
I have found a strange behavior of PB when I use a DataStore into a user function. If I run the projet directly from powerbuilder the function returns the info correctly, but if I run from .EXE it does not work as expected.
I prepared and attac...
GET USERPROFILE FOLDERS
- Resolved
- How-to
- Last updated 3 years ago
- Benjamin Gaesslein replied 3 years ago
Hi,
i'm migrating from PB 12.5 to PB 2019-R2.
In PB 12.5 to get the path of the userprofile folder, I used this syntax declaring an external global function.
FUNCTION Long GetTempPath(Long nBufferLength, REF String lpBuffer) LIBRARY "KERNEL32.DLL"...
Getrow() Function with N-Up Datawindow
- Resolved
- How-to
- Last updated 4 years ago
- Neil Prichard replied 4 years ago
i am trying to use the getrow() function with infomaker version 2017 R2 Build 1769 however because the report i'm developing is requiring the N-Up Datawindow it is throwing the function off , see below. Is there as way i can use this function or any ...
Order of operations when posting a function call
- Resolved
- Advice
- Last updated 4 years ago
- Miguel Leeuwe replied 4 years ago
I just want to confirm my understanding. Suppose I have the following (over-simplified) code:
nvo_myobj objobj.StringValue = "foo"w_mywindow.Post wf_do_something("The value is: " + obj.StringValue)DESTROY obj
Is that OK, because the function argume...
GetContextService Crash on dll Deployment
- Resolved
- Issue
- Last updated 5 years ago
- Chris Pollach @Appeon replied 5 years ago
I have a user function object used to open a web browser that causes a crash when deploying the project but only when the option to create machine code and a .dll library is selected. Deployment with Pcode as well as machine code without a .dll libr...
Rowscopy issue in runtime only
- Issue
- Last updated 6 years ago
- Govinda Lopez @Appeon replied 6 years ago
Hi,
I use a simple Rowscopy() function. When i test it with Debug it does the job (return 1)
When i deploy it in 32 bits... The same statement return -1
Is it a runtime DLL issue?
Thank's.
Marco
I.e. : It's a old system from...
How to create a complier to test the result
- Issue
- Last updated 6 years ago
- Chris Pollach @Appeon replied 6 years ago
I would like to write a number to words function in powerbuilder 2017
I google for some solution but I don't know whether the syntax is correct so I would to run in application.
However, I was new to powerbuilder and have no idea to find a ...
date-function in PB 2017 different to 12.6?
- Issue
- Last updated 6 years ago
- Chris Pollach @Appeon replied 6 years ago
Hi,
I just migrated my project to PB 2017 1681 and run into an error because the behavior of the powerscript function date(string) appears to be changed. In PB 12.6 this:
date('2018-01-53') returns 1900-01-01, what I need.
But in PB ...
Hi Can anyone help
I have a oleobject dll that I need to accesS - I have the following code
OLEObject objDEPHandler
string strError
long numResultCode
integer li_port,li_ret
li_port=1
objDEPHandler = create OLEObj...
Please ADD file location open function at System Tree...
- Issue
- Last updated 6 years ago
- Roland Smith replied 6 years ago
I wanna open the file location at System Tree or Libray Painter.
Thanks
...
bad runtime function reference powerbuilder 21
- Resolved
- Issue
- Last updated 6 years ago
- Marco Meoni replied 6 years ago
i get bad runtime function reference powerbuilder 21
in retrieve event
any help ?
...
- Page :
- 1