Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 3 years ago
  2.  Tjafzfa Gsjsf replied 8 months ago
6 replies
22122 views
15 votes
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...
John Fauss John Fauss
  1. PowerBuilder
Please Update Your Queries With The Solution
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
3 replies
5357 views
12 votes
Saw this and thought it was perfect. Note the angry mob in the background on panel 4.   :)
Olan Knight Olan Knight
  1. PowerBuilder
Outer Join syntax from PB to ANSI
  1. How-to
  1. Last updated 5 years ago
  2.  Luca DG replied 5 years ago
3 replies
3186 views
0 votes
Hello  I have several datawindows coming from an old application with graphic SQL written win Powerbuilder outer Join syntax (*= or =*). For example: select student.name, student_email.email from student, student_email where student.id *= student_e...
  1.  DataWindow
  2.  SQL Server
Luca DG Luca DG
  1. PowerBuilder
Using a REGISTRATION-FREE .Net DLL in PowerBuilder
  1. Issue
  1. Last updated 7 years ago
  2.  Aron Cox replied 5 years ago
6 replies
4557 views
0 votes
I created a .Net DLL (COM) and managed to use it in PowerBuilder (12.5 Classic)... so far so good... The downside that we need te register this DLL in order to be able to use it. Ive read that theres possibility to use such a DLL without registra...
  1.  COM
Marc Schmidtmayer Marc Schmidtmayer
  1. PowerBuilder
PB 2019 Migration Failure to Launch...
  1. Issue
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
2 replies
2260 views
0 votes
My application was developed in PB 12.5 and I am migrating it to PB 2019. It runs from the IDE, but the deployed version on IDE machine errors out with message: DBMS OLE DB is not supported in your current installation, where PROVIDER='SQLOLEDB'. On ...
Lynn A Haynes Lynn A Haynes
  1. PowerBuilder
Object dot notation examples for .NET Datastore
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Don Olliver replied 5 years ago
7 replies
2962 views
0 votes
Using PB 2019, we have migrated several datastores to a SnapDevelop .NET assembly. Looking through the various tutorials and sample projects, we do not see any examples of accessing datastore column values using object dot notation. All appear to use...
  1.  SnapDevelop
  2.  .NET DataStore
Don Olliver Don Olliver
  1. SnapObjects
Should we replace POS with POSA in PB 2017r3
  1. Advice
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
2 replies
2279 views
0 votes
Hello All, During the migration of PB9 application to PB17r3. The POS function is automatically replaced with POSA in some places. However some places as it with POS function. So it is required to change manually POSA at the place of POS function. ...
  1.  Migration
prashant kaushik prashant kaushik
  1. PowerBuilder
PBC190 CGEN resource compiling error
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  René Ullrich replied 5 years ago
1 reply
1806 views
0 votes
Using PowerBuilder 19 and standalone compiler PBC190. All works as expected in PowerBuilder 19. When using PBC190, the creation of the dll's failes.Elevated Commandline is:pbc190.exe /d "E:\_troubleshoot\Ada\ada.pbt" /o "E:\_troubleshoot\Ada\ada.exe...
Susana Domingos Susana Domingos
  1. PowerBuilder
PBC190 performance issues
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Susana Domingos replied 5 years ago
1 reply
2150 views
0 votes
Hi, We have a workspace with 10 different projects; one of the projects has 20 additional libraries. This project takes 1m24s to compile using the PowerBuilder 19 IDE. Using the PBC190 utility takes over 2h (using Microsoft Azure Cmd task). Is ther...
Susana Domingos Susana Domingos
  1. PowerBuilder
PB 2017 with Oracle 18c
  1. Advice
  1. Last updated 6 years ago
  2.  Thomas George replied 5 years ago
8 replies
11820 views
0 votes
Hi Team, Can I use Oracle 18c with powerbuildr2017. Please advise.   Regards Nikesh
Nikesh Mishra Nikesh Mishra
  1. PowerBuilder
Decimal to Formatted String
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
3 replies
4118 views
0 votes
Hello all, I need to convert a decimal number in a variable "1234.22" into a string and need it in the format "1,234.22" (money) such that I can display it on a text field when the program is run. I am unsure of how I can approach this.. I know the ...
  1.  PowerBuilder
Raj Kumar Raj Kumar
  1. PowerBuilder
Oracle PL/SQL
  1. How-to
  1. Last updated 5 years ago
  2.  René Ullrich replied 5 years ago
2 replies
2921 views
0 votes
HELP!When we "upgraded" to Oracle 12C from Oracle 11g several years ago, we started seeing the following EVERY. SINGLE. TIME. we connected to a database in both SQL+ and when running a script in SQL+. We use standard PL/SQL and run the scripts in SQL...
Olan Knight Olan Knight
  1. PowerBuilder
DDDW with values based on another column
  1. How-to
  1. Last updated 5 years ago
  2.  Marco Meoni replied 5 years ago
1 reply
2664 views
0 votes
Hi,I have 2 columns in DW, both of them are DDDWmethod and symbol Method DDDW is like:id(data_col)  method(disp_col)  symbol 1                  met_1                 X 2                  met_2                 X 3                  met_3           ...
  1.  DataWindow
  2.  PowerBuilder
Michał Misijuk Michał Misijuk
  1. PowerBuilder
Removing non-PB files from git repository in PowerBuilder 2017
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Tom Jiang @Appeon replied 5 years ago
1 reply
2695 views
0 votes
I have an existing project that I moved into source control and have been managing from the built in source control in the PowerBuilder IDE. My diff tool is TortoiseGit 2.6. When I inherited the existing project there were extra files and folder in t...
  1.  Git
  2.  TortoiseGit
Lawrence Anderson Lawrence Anderson
  1. PowerBuilder
Connecting to Oracle from mobile device
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Armeen Mazda @Appeon replied 5 years ago
4 replies
2508 views
0 votes
I'm late to this topic so I must assume it has been asked and answered many times but I need to ask: I'm embarking on building an app to run on a tablet (iPad). My question is: How does this app connect to an Oracle database residing on a server in ...
  1.  Cloud
  2.  Oracle
  3.  PowerBuilder (Appeon)
Larry Peters Larry Peters
  1. PowerBuilder
Edit mask in PowerServer
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Bryant Burnard replied 5 years ago
2 replies
2385 views
0 votes
Hi We are using 2017 R3 Build 1858 for both PowerBuilder and PowerServer. (Oracle back end, Azure for PowerServer) We are using an edit mask to present a drop down calendar. Using only the mouse to select a date in the calendar we have noticed tha...
  1.  32-bit
  2.  64-bit
  3.  Azure
  4.  Client
  5.  PowerBuilder (Appeon)
  6.  PowerServer Web
Bryant Burnard Bryant Burnard
  1. PowerServer 2020 or older (Obsolete)
Is using C# to write scripts instead of Powerscript possible? If not can you direct me to documentation for sending/receiving data from a WebApi within the PB IDE?
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Ricardo Jasso replied 5 years ago
3 replies
2537 views
0 votes
Can you use C# to write scripts for a window instead of powerscript? If not, can you direct me to any documentation on how to make a call to a REST service from a data window? I'm confident I can create a WebApi with SnapDevelop, but I don't yet kn...
  1.  C#
  2.  REST
  3.  Script
Sabir Foux Sabir Foux
  1. PowerBuilder
Powerbuilder.Datawindow, update returns 100
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
4 replies
2537 views
0 votes
Hi,I'm having problem with update function.it gives me result -1 and sqlcode 100, and i can not find out why.Data window has set update properties (key columns, use update),tab order (not on every column) and everything looks fine, but update still g...
Michał Misijuk Michał Misijuk
  1. PowerBuilder
Datwindow saveas not working.
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Olan Knight replied 5 years ago
10 replies
3897 views
0 votes
I am attempting to Save a datawindow.  It works fine if I run it through the PowerBuilder IDE, but when I compile and create an executable i will not save a file.  It returns that it is successful but it does not save the file.  Code snippet below: ...
  1.  DataWindow
Bernie Rivera Bernie Rivera
  1. PowerBuilder
Composite Datawindow Report
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Olan Knight replied 5 years ago
2 replies
2634 views
0 votes
Hello all, I am trying to build a report through composite data window and my child data windows have different retrieval arguments (one is bounded by date whereas the other one is a list of all items). What I need to do is display the pieces of the...
  1.  Data
  2.  Database
  3.  DataWindow
  4.  Filter
  5.  PowerBuilder (Appeon)
Raj Kumar Raj Kumar
  1. PowerBuilder
How to fill an external PDF File (Forms)
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
2279 views
0 votes
Hi, We have some external PDF Files to fill out with some datas from our database. We don't want to replicate these PDFs in a datawindow because it will take time to reproduce the hole form design.  Which is the best way to accomplish this?   Tha...
MARKOVIC Marko MARKOVIC Marko
  1. PowerBuilder
Create PBD with resources in a PBR (Relative path)
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
6 replies
3066 views
0 votes
Hi Appeon Community, I have troubles to create PBDs with resources in a PBR when the PBR path is relative.   I am using Appeon PowerBuilder 2017 R3 Build 1880. Please let me know, how I can figure out this issue. Thank you.
Moises Mescua Moises Mescua
  1. PowerBuilder

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