Discussions tagged Embedded SQL
How do we use a Parameter more than once in a dynamic SQL with one Argument
- How-to
- Last updated 3 months ago
- René Ullrich replied 3 months ago
We are using PB17 and SQLAnywhere 17
We have a generalized routine whereby we can pass a SQL query which takes one argument.
The problem is that some queries need to reference the same argument more than once.
As we understand it - if you use the ...
Decimal values incorrectly passed to SQL Server as varchar
- Issue
- Last updated 6 months ago
- Bernhard Giesriegl replied 6 months ago
Using SQL Server and Powerbuilder 2022 R2 build 2819, I found another bug:
If I have the following:
decimal ldec_valuelong ll_id
ll_id = 1
ldec_value = 7.99
UPDATE my_table SET my_old_price = CASE WHEN :ldec_value <> my_old_price then...
SQL Server DateTime issue with Login Default Language "British English - British"
- Resolved
- Issue
- Last updated 8 months ago
- Markus Eckert replied 8 months ago
Problem with PB19 (and I expect with PB22) inserting DateTime data into SQL Server (V2019) using either SQL Native Client or MSOLEDB. If the Login's Default Language is "British English - British" then we get an error:
MS OLE DB Driver for SQl Serve...
Events in a transaction object (n_tr) like retrievestart/-end for logging purposes.
- How-to
- Last updated 9 months ago
- Olaf Bönning replied 9 months ago
I like to log the begin and the end of an SQL statement because i like to measure the time the SELECT needed.
In datawindows i have the retrievestart and retrieveend events where i can exactly do what i wish to do.
In embedded SQL i use SQLCA which...
SQL select from PowerBuilder returns only part of data
- Resolved
- Issue
- Last updated 1 year ago
- MARK APTEKAR replied 1 year 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...
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 1 year ago
- René Ullrich replied 1 year ago
Hi all, have a happy new year!
I could not find another way to post an enhancement request for future PB versions, so I'll leave it here. If there is a better way to do so, please let me know.
We develop and maintain a quite large c/s application (...
Embedded SQL input variable value max length
- Misc
- Last updated 2 years ago
- Peter Pang @Appeon replied 9 months ago
Hi,
I have some questions about the length of string input variable value in PowerBuilder embedded SELECT statement (PB 2019 R3 + SQL Anywhere 17).
We have some legacy PB code which splits string into 65535 character pieces, writes them to a temp. ...
Embedded SQL Issue / Guidance
- Resolved
- How-to
- Last updated 3 years ago
- Paul Murray replied 3 years ago
Greetings All,
I have an SQL call that I would like to execute in my script. It works fine in the SQL Manager, but PowerBuilder is not happy about it.
PowerBuilder did not like the Declare statement, so I tried moving 'POINT' into the select state...
Check embedded SQL when doing a full build
- How-to
- Last updated 3 years ago
- Markus Schröder replied 3 years ago
Hello,
when i do a full build of my workspace, Powerbuilder sends the embedded sql commands to the database.
Does Powerbuilder display incorrect sql statements anywhere? (in a postgres database i can see the incorrect statemants in a database logfi...
PowerServer Execute Immediate Use Database
- Resolved
- Advice
- Last updated 3 years ago
- Armeen Mazda @Appeon replied 3 years ago
Hi,
Greetings!
I have one PowerBuilder application that uses embedded SQL to change the context to a different database using the transaction object.
Execute Immediate "Use Database_Name";
where Database_Name is the database name
But when this ...
I like to generate a stored function in iAnywhere 17.
The code, tested in Central works fine, but I want to create the function in the database if not exits during software application using EXECUTE IMMEDIATE (:ls_sql_string).
But there are double ...
Is datawindow sql considered embedded sql?
- Resolved
- Advice
- Last updated 4 years ago
- Chris Pollach @Appeon replied 4 years ago
I am preparing for a Powerbuilder upgrade from 8.0 to 2019. I will be moving embedded sql to stored procedures and db functions. Is the sql in datawindows considered embedded sql and is it a good practice to move it to stored procedures and have the ...
How to Make SnapObject 2.0 Use run the query from DwSelectAttribute
- Resolved
- How-to
- Last updated 4 years ago
- Gbenga Owolabi replied 4 years ago
I have been on this for days.
Please help with the snapobject v.2.0 usage below.
How do i make snapobject to run the multi-table sql query defined in DwSelectAttribute on the D_Rpt_Mm_Tbills poco class
public List<D_Rpt_Mm_Tbills> Test(param...
Select BLOB column with embedded SQL in Snap Develop 2019, not the R2
- How-to
- Last updated 4 years ago
- paulo gomes replied 4 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...
Hello,
I have a simple Oracle stored function as follows:
CREATE OR REPLACE FUNCTION test_double(a_in NUMBER) RETURN NUMBER ISBEGIN RETURN a_in;END test_double;
And a simple test window with a multilineedit and command button whose clicked event s...
SQL transaction not working
- Resolved
- Issue
- Last updated 5 years ago
- Michael Kramer replied 5 years ago
Hello.
I´m trying to execute some exclusions in database
this is the code
DELETE FROM CONTRATO WHERE PESSOA_ID = :ID_PESSOA
DELETE FROM PESSOAS WHERE ID = :ID_PESSOA;
commit;
if sqlca.sqlcode < 0 then
MessageBox ("Erro na exclusão de dados"...
Auditing Triggers + Single SQLCA Transaction
- How-to
- Last updated 5 years ago
- Matthew Balent replied 5 years ago
PowerBuilder classic, currently using PB 2017
SQL Server
I have a large old PowerBuilder application + satellite applications. Like many large old PowerBuilder applications it uses SQLCA for 99% of its transaction handling. It also uses stored ...
IDE Setup
PowerBuilder 2017 R3 Standard Edition, build 1858.
Connected to MSSQL 2012 (SP4) using ADO.NET.
System Options as follows:
[ ON ] Free Database Driver Libraries on Disconnect
[ OFF ] Disable database connection when compiling and...
Migrate NVOs from EAS web app to REST Web API with PB 2019/Snap Develop
- Advice
- Last updated 5 years ago
- Ricardo Jasso replied 5 years ago
Hi all,
We are evaluating the efforts to migrate PB NVOs from an EAS web app to REST API using Snap Develop and PB 2019.
We already migrated few methods using the IDataStore object. However we noticed that several methods were missing from the orig...
Embedded SQL Select - Stringsize
- Issue
- Last updated 6 years ago
- Chris Pollach @Appeon replied 6 years ago
Hi,
is there an option to modify the maximal string size that can be selected with embedded SQL Select?
At the moment there is a limit of about 32000.
This is my workaround at the moment (dw_syntax can be larger than 32k):
selectblob dwsy...
- Page :
- 1