Discussions tagged Embedded SQL

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 ...
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 :ldec_v...
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...
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...
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...
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 (...
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. ...
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...
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...
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 ...
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 ...
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 ListD_Rpt_Mm_Tbills Test(params object...
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...
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 However nothing happens in database. I need to ...
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...

Find Questions by Tag

.EXE .NET 6.0 .NET Assembly .NET Core 3.1 .NET Core Framework .NET DataStore .NET Std Framework 32-bit 64-bit ADO.NET AEM AI Algorithm Amazon AWS Android Apache API APK App Store App Store (Apple) Appeon Workspace Appeon Xcelerator Plug-in Architecture Array ASE Asynchronous Methods Authentication AutoBuild AutoCompiler Automated Testing Automation AutoScript Azure Barcode Base64 Batch BigData BLOB Branch & Merge Browser Bug Build Button C# C# Class Importer C# Editor C# Model generator Calendar Camera Certificate Chrome Citrix Class Client Client/Server Cloud Cluster Collection COM Command Line Compiler Compression Computed Field Configuration Controls Cookies Cordova Crash Cross-Platform Crosstab CSharpAssembly CSharpObject CSS CSV Cursor Data Database Database Driver Database Painter Database Profile Database Provider DataObject DataSource DataStore DataStore (C#) DataStore (PS) DataType DataWindow DATE DATETIME DB2 Debug Debugger Debugging Deployment Design DLL DO-WHILE Dockable Docker Documentation DOUBLE Download DragDrop Edge Edit Style Editor Elevate Conference Email Embedded SQL Emulator Encoding Encryption Enhancement Request Entity Entity Framework ERP Error Event Event Handler Event Handling Excel Exception Export Expression External Functions F# Field File File Access Filter Firefox Firewall Font FOR-NEXT Foreground Format Function Garbage Collection GeoLocation Git Graph HANA Hash Header HTML/5 HTTP/S HTTPClient Icon IDE Identity IIS IMAPI Import InfoMaker Inheritance Installation Integer IntelliSense Interface Internet Internet Explorer iOS IPA iPad iPhone IWA J# Java JavaScript JBoss JDBC JOIN JSON JSONGenerator JSONParser Kestrel Label Lambda Large File LDAP Library License LINQ Linux OS Load Balancing Localization Localized PBVM Log In Log Out Logging LONG LONGLONG macOS MAPI Maps MDI Memory Memory Leak Menu Merge MessageBox Messagging Method Migration MIME TYPE Mobile Model ModelStore ModelStore (C#) MSOLEDBSQL Multi Threading MVC MySQL n-Tier Namespace NativePDF NVO OAuth ODATA ODBC Office Offline OLE OLEDB Online Open Source OpenAPI OpenSSL Oracle OrcaScript Other Outlook Output Package Parameter Patch PayPal PB Classic PB Native PB.NET PBC PBD PBDOM PBG PBJVM PBL PBNI PBORCA PBVM PBX PDF Performance Permission PFC Picture Pipeline Play Store (Google) Plugin Popup Port POST PostgreSQL PowerBuilder PowerBuilder (Appeon) PowerBuilder (SAP) PowerBuilder Compiler PowerBuilder Runtime PowerClient PowerScript (PS) PowerScript IDE PowerScript Migrator PowerServer PowerServer Mobile PowerServer Toolkit PowerServer Web PowerServerLabel Print Properties Proxy Publish PULL PUSH Query Regression Release Renew Resize Response REST Retrieve RibbonBar RibbonBar Builder Rich Text Roadmap RPC Runtime Packager SaaS Scaffolding Script SDI SDK Security Server Service Session Single Sign-on Size SMTP SMTPClient SnapDevelop SOAP Sort Source Code Speech Recognition SQL SQL Anywhere SQL Server SqlBuilder SqlExecutor SQLite SqlModelMapper Storage Stored Procedure Subscription SVN Swagger Syntax TabbedBar TabbedView Tablet TabPage Target TE Control Testing Text TFS Theme TIME Timer TLS/SSL Tomcat TortoiseGit TortoiseSVN Transaction Transparency Trial Trigger TRY-CATCH TX Control Type UI ULONG UltraLite Uninstall Unit Test Unit Testing UNIX OS Update Upgrade Upload URL User Center User Object UWP Validation VARCHAR Variable Versioning Visual Studio Visual Studio Code VM Voice Warning WCF Web API Web Extensions Web Service WebBrowser WebForms WebLogic WebSphere WildFly WinAPI Window Windows OS WinForms Wizard Workgroup Workspace WPF XCODE XHTML XML Zoom