Discussions tagged Parameter
Stored procedure parameter by reference returns 0 instead of null
- Issue
- Last updated 5 months ago
- Erwin Anema replied 5 months ago
Hi all,
While upgrading a legacy application from PB17R3 to PB2022R3 I run into a reproducible issue with calling an MSSQL stored procedure which has an integer output parameter.The issue is that when the proc's output parameter is null, PB17R3 corr...
SAP IQ Database Connection From PowerBuilder application Error
- Issue
- Last updated 9 months ago
- Miguel Leeuwe replied 9 months ago
Dear everyone,
I am having an issue creating a IQ db connection from our application. I do not wish to use ODBC connection (I tried it's working fine).
On my computer and user computer SAP IQ Client Suite 16.0 sp08 (64-bits) is installed. My P...
Hello,
This is a long time issue for me:
Are there any start parameters for the Powerbuilder IDE? Currently I open a specific workspace by double clicking on the pbw file. That's OK. But very often have to change "DB Profile"too. And I always do th...
After upgrading Oracle Database to version 19c - we have an issue, a runtime failure when a stored procedure with an input parameter of a table type or an array is being called from the PBL.
Power Builder: Version 2019 R2 Build 2353
Oracle Database...
Hi,
I just migrated my PB10.5 application to PB2021. Everything seems to be running great on the development machine including the database connection.
When I tried on a client machine, I realized that I needed to install VC++ 2010 runtime, which ...
We are testing deployment of our application with Powerclient. One issue we have yet is being able to run the application via a windows shortcut (or windows scheduled task) using parameters.
In the past, this would have been our start line:
c:\pr...
PowerBuilder 2021 Runtime without set regedit
- How-to
- Last updated 3 years ago
- hoai bao replied 3 years ago
Dear All
PowerBuilder 2021. How to set the PowerBuilder Runtime path for when running PB210.exe.? without set registry editor.
does the Powerbuilder IDE currently have any parameters?
example : run(PB210.exe -path d:\\PowerBuilder Ru...
Hi Team, We currently connect to SAPGUI 7.5 with saplogon.ini file. We need assistance in connection Powerbuilder to SAPGUI 7.6 with xml file.Thanks....
load sqlselect from model without params
- How-to
- Last updated 3 years ago
- David Xiong @Appeon replied 3 years ago
is it possible to load a sqlselect from a model without params?
I have this structure:
[SqlParameter(name: "first", dataType: typeof(int))][SqlParameter(name: "second", dataType: typeof(int))][FromTable("mytable", Schema = "DBA")]
[SqlWhere("...
How to send Exe parameters using batch file ?
- Resolved
- How-to
- Last updated 4 years ago
- Michael Kramer replied 4 years ago
Environment :
PB2017 R3 , Windows 10
Batch file has the following command to open "abc.exe" executable from "destination" folder
start "" "%destination%\abc.exe" "Parm1"
But the Parm1 is not passed to application, although the Run command works...
Select BLOB column with embedded SQL in Snap Develop 2019, not the R2
- How-to
- Last updated 5 years ago
- paulo gomes replied 5 years ago
Hi All,
There is a blob column in one of our Oracle database that has to be displayed to the Users in our web site.
We are coding a new REST Web API that one of our web sites is consuming the methods.
The Snap Develop is the PB 2019, not the PB 20...
Powerserver Data Source (MSSQL) Disablebind
- How-to
- Last updated 5 years ago
- Kai Zhao @Appeon replied 5 years ago
Hi All,
We have numerous SQL Server Data Sources defined in our Appeon Powerserver AEM, to connect to various SQL Server Database.
In our Mobile App, we use the Cachename to connect our SQLCA object to the DB.
We now have a requirement to display ...
Re: Passing array into an sql
- Resolved
- How-to
- Last updated 6 years ago
- Matthew Balent replied 6 years ago
Hello,
Using PowerBuilder 2017 R3, PostgreSQL 11
Need to pass a string array value to the following query, written in an itemchanged event.
Select count(*) into :ll_count from tableA where series in (:ls_array);
Tried:
Method 1:String ls...
What's the format of a String Array as a DW Parameter?
- Resolved
- Issue
- Last updated 6 years ago
- Andreas Mykonios replied 6 years ago
PBv12.1, b7055
Oracle 12C
I've inherited PBv9 code that uses a string arr as a retrieval argument in a dw.
I migrated the code to PBv12.1, and now the dw fails on the retrieve and returns zero rows.
- When I take the parameters and ent...
Declare procedure calls different between 10.5 and 2017
- Issue
- Last updated 7 years ago
- Chris Pollach @Appeon replied 7 years ago
Hi,
I'm comparing 10.5 and 2017, trying to get the backing to move to 2017. I've come across an interesting issue that has me stumped.
Basically we have the following code
DECLARE OKButtonOnlyForm PROCEDURE FOR SYSADM.p_OKButtonOnlyF...
- Page :
- 1