Featured Questions
Q&A Forum Tip: Including Source Code in Your Question
- Advice
- Last updated 4 years ago
- Manuel Rivera replied 2 weeks ago
A recent post included some PowerScript code, and I thought I would pass along a tip for pasting code snippets that produces a slightly more readable result than simply pasting code into the website's text editor.
The toolbar contains a button to as...
            Please Update Your Queries With The Solution
- Resolved
- How-to
- Last updated 4 years ago
- Olan Knight replied 4 years ago
Saw this and thought it was perfect. Note the angry mob in the background on panel 4.   :) 
            How to know query datatype
- How-to
- Last updated 1 year ago
- Mario Francisco Celleri replied 1 year ago
Hi guys;
 
Thanks for your time. I need to know what type of data retrieve a query; when use a datawindow.
I put into context what require or intend to do.I have several queries to make to a database; on several tables, with different types of dat...
                    
            Support for Powerbuilder 2021 and new MSOLEDBSQL 18.7 Drivers
- Resolved
- How-to
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
 
**EDITED TO CLARIFY PREVIOUS SUPPORT, NOT FUTURE SUPPORT**
Is Powerbuilder 2021 supported for the new MSOLEDBSQL 18.7.2 drivers released on April 9th this year?
Has anyone updated to the newest 18.* driver and had success with existing applicati...
                    
            Is there a way to control / trigger the windows scroll event?
 
Let's say I have window_1. Window_1 has a vertical scroll bar.
I have 5 dw's lined up vertically on the window so I need a vertical scroll bar on the window to place/view all of the d...
            Good morning,
I am trying to connect to an Azure DB (SQL 2014), using PB 2022 R3 Build 3356. I have tried both "SNC SQL Native Client(OLE DB)"
and "MSOLEDBSQL SQL Server" DB drivers, but I get the following error on both.
SQLSTATE = 08001Microsoft...
            How to Access values of a Datawindow in window A from Window B
- How-to
- Last updated 1 year ago
- René Ullrich replied 1 year ago
I am using Powerbuilder 2022. I have a requirement as follows.
 
Consider 2 windows Window A and Window B. 
In Window A, i have retrieved a person detail and it always will have only one row. 
Now i open Window B and when I click a button, I have...
            Are the apps rendered as html, css and javascript using the app-laucher?
- Resolved
- How-to
- Last updated 1 year ago
- Gzim Ramizi replied 1 year ago
Hi all
what really happens in the background and what is true? i have queried two current AI engines and get different answers. Does it depend on whether you are making a new application or deploying an existing one?
 
We are using PB/PS 2022 R3. ...
            High volume text or excel file import in powerserver
- How-to
- Last updated 1 year ago
- Narayana Bhat P replied 1 year ago
Hi Team,
 
What is the best method to import high volume text or excel file. For example having column 20 and no of line 50000
 
We have tried using datawindow import and reading 100 line each loop till we get datawindow import error, but this wo...
                    
            PB 2022 R3 program closes when saving to Excel Xlxs file type
- Resolved
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Just recently upgraded to PB 2022 R3. When the user tries to save as an Excel .xlxs file type the program closes. I have in the directory with the executable the dll file "Sybase.PowerBuilder.DataWindow.Excel12.dll" which has resolved this problem wi...
            PowerBuilder migration 2022 R3 in Windows 10 machine
- How-to
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
Hi Team,
 
We are planning to migrate Powerbuilder 2017 R3 code to 2022 R3 code to have the application running in Windows 11 machine but we are using windows 10 machine for migrating the application. Please let us know whether application built in...
            Call an API to send a file
- How-to
- Last updated 2 years ago
- David Peace (Powersoft) replied 1 year ago
Hi, How can I call an API to send a file? Body contains form-data. Could you help me? Thanks.
            Hi everyboy.
I am looking for a way to open a send email window with an attachment with the new Outlook from a Powerbuilder application.
Apparently this new version is no longer compatible with COM or VSTO or (MAPI ? )
https://learn.microsoft.com/...
                    
            Creating multi level JSON script from Datawindow
- How-to
- Last updated 1 year ago
- David Peace (Powersoft) replied 1 year ago
I try to achieve multi level JSON script from datawindow. It suppose to looks like a family tree:
[
  {
     name: "Canada",
     people: [
       {
          name: "Steve",
          children: [
            {
               name: "Linda",
...
            database transaction information not available
- Issue
- Last updated 1 year ago
- David Peace (Powersoft) replied 1 year ago
PowerBuilder window throws 'database transaction information not available’ error when trying to retrieve. We are using ADO.NET as DBMS type and Namespace is system.data.sqlclient for SQL connection. Could you please tell me how to resolve the error?...
            How can I start powerserver outside of powerbuilder with a script?
- Resolved
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hi all
Is there a description where I can read how to start powerserver outside of PowerBuilder (IDE) in order to be able to call the deployed applications?
 
PowerBuilder/PowerServer 2022 R3.
 
TIA,
gzim
            Datawindow date format - Auto conversion to different timezone
- Resolved
- How-to
- Last updated 1 year ago
- Ganesan Rajan replied 1 year ago
Hi,
I have a query related to Datetime format in DWs. i,e does DW automatically convert datetime value to local time zone?
We have a datawindow displaying Order Date. Column style type is Edit and Format is dd/mm/yyyy hh:mm.
The Datasource is an S...
            PBG file being deleted when PB IDE regenerates the PBLs
- Resolved
- Issue
- Last updated 1 year ago
- David Peace replied 1 year ago
Hi
Just testing GIT for source control. We have pushed our PB app to Git and the cloane t to another PC. PB IDE says there are no PBLs with is correct and then regenerates them. It deletes the PBG files from the local folder. A push back from the cl...
            PB 2022 R3 3289 - Theme Border and Resize Behaviour
- How-to
- Last updated 1 year ago
- Tracy Huang @Appeon replied 1 year ago
Hi,
according to the specification of the "Theme enhancements" in PB2022 R3, a MDI-Sheet with borders between 2 and 8 pixels should have the specified number of pixels as border width:
https://docs.appeon.com/pb/whats_new/ch01s01s08.html#Theme_resi...
            Hello Team,
Please let us know whether the issue still persists. We are working with PB2022 R2 (1878). 
"When we got a requirement to change the delimiter in csv, we changed saveas to SaveasFormattedText. The function works for small result sets Bu...
                    
            HOW TO ADD BYTE ARRAY ATTACHMENT TO SMTP MAIL
- Resolved
- How-to
- Last updated 1 year ago
- lingaiah T replied 1 year ago
Dear Team,
I have a  Datawindow for printing, Instead of print I will do save as PDF, and attach to email.
So, Instead of Save PDF! to disk, can I attach on fly or dynamically to SMTP EMAIL.
 
EX: 
lnv_SmtpClient.Message.AddAttachment("c:\imag...
            Unable to find the requested .Net Framework Data Provider
- How-to
- Last updated 1 year ago
- Mike Kolenda replied 1 year ago
Version 2019 R2 Build 2353
We have a PowerBuilder application (32-bit) that connects to a .NET DLL via OLE. Within this DLL we connect to Oracle using Provider Factories. We recent decided to stop using “System.Data.OracleClient” and have begun usin...
                    
            
                Loading...
            
        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 
                     DPI 
                     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 
                     RibbonView 
                     Rich Text 
                     Roadmap 
                     RPC 
                     Runtime Packager 
                     SaaS 
                     Scaffolding 
                     Script 
                     SDI 
                     SDK 
                     Security 
                     Server 
                     Service 
                     Session 
                     Single Sign-on 
                     Size 
                     SMTP 
                     SMTPClient 
                     SnapDevelop 
                     SOAP 
                     Solution 
                     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 
            
     
                             
                             
                             
                             
                             
                            