Discussions tagged Embedded SQL

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...
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"...
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...
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...
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