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
How to use array in IN clause?
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Rômulo Sorato replied 5 years ago
5 replies
4486 views
0 votes
Hello. I´m trying to delete multiple rows in a function passing an array to IN function and i made this sql :   DELETE FROM CONTRATOS WHERE ID IN (:DELETED_IDS)   Powerbuilder is returning me an error "variable reference in database statement...
  1.  SQL Anywhere
Rômulo Sorato Rômulo Sorato
  1. PowerBuilder
Multiple Threading like. Net and Java in PowerBuilder 17 or 19
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
2 replies
1966 views
0 votes
Do you guys worked/ planning to introduce multiple threading concept like .Net and Java?
Kal P Kal P
  1. PowerBuilder
Speech to Text Compatibility
  1. How-to
  1. Last updated 5 years ago
  2.  Armeen Mazda @Appeon replied 5 years ago
2 replies
2474 views
0 votes
Do you guys have tested/ worked on any Speech-To-Text recognition software compatibility with any of the version of PowerBuilder? We have a request coming from our client to have that in our software.   We are currently working on the PowerBuilder...
Kal P Kal P
  1. PowerBuilder
Issue with fileservice
  1. Advice
  1. Last updated 5 years ago
  2.  Winston Bautista replied 5 years ago
2 replies
1996 views
0 votes
I am using fileservice for powerserver by uploading PDF files.   The pdf file is only working in IOS devices and Android devices show 0 bytes.  Can anyone help?
Winston Bautista Winston Bautista
  1. PowerServer Mobile (Obsolete)
Unexpected Character Set After Performing Base64Decode()
  1. How-to
  1. Last updated 5 years ago
  2.  Miguel Leeuwe replied 5 years ago
3 replies
2882 views
0 votes
Hi, I'm currently using PB2017R3 and attempting to utilize the new CrypterObject and CoderObject functionality. I have a text file that contains encoded / encrypted information. I wish to open the file, read the file contents and decode/decrypt var...
  1.  Base64
  2.  Encoding
  3.  Encryption
  4.  PowerBuilder
Jason Schultz Jason Schultz
  1. PowerBuilder
Take a Picture from a WebCam
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
3232 views
0 votes
Hi everyone, I'm new in PowerBuilder, and I need to take a picture from a webcam, obviously I need to show the webcam video, can you help me? 
  1.  Camera
  2.  Picture
  3.  PowerBuilder (Appeon)
Leandro Espino Leandro Espino
  1. PowerBuilder
PB2017 Appeon MS Web Browser Control Issue
  1. Advice
  1. Last updated 5 years ago
  2.  Balu Krishnasamy replied 5 years ago
6 replies
3907 views
1 vote
Microsoft Web Browser Control Issue: We Upgraded to PB 2017 R3(1858) recently. Ever since we deployed our application using PB2017, there has been intermittent issues with respect to the way how the MS Web Browser Control displays the site. We do ha...
  1.  OLE
  2.  PowerBuilder (Appeon)
Balu Krishnasamy Balu Krishnasamy
  1. PowerBuilder
input string was not in a correct format
  1. Issue
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
5 replies
3349 views
0 votes
Hi all!I got that on Appeon web when trying to retrieve.I guess it is a problem with decimal configuration, but I cant find an answer.Can anybody help me?Im using Appeon 2019 with Oracle 11g and my decimal separator is ","This is the result running o...
  1.  Oracle
Gerardo Barquero Gerardo Barquero
  1. PowerServer 2020 or older (Obsolete)
SQL transaction not working
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Michael Kramer replied 5 years ago
5 replies
2362 views
0 votes
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 ...
  1.  Embedded SQL
Rômulo Sorato Rômulo Sorato
  1. PowerBuilder
Datawindow border on top and double border
  1. How-to
  1. Last updated 5 years ago
  2.  Olan Knight replied 5 years ago
1 reply
2382 views
0 votes
Hi Everyone, Just wanted to ask, if there are any possible way to accomplish border on top and double border on datawindow's object? Any dll or script that will do the trick? I am using PB 2019. Thank you!
  1.  Appeon Workspace
  2.  DataWindow
  3.  DLL
  4.  PB Classic
  5.  PowerBuilder
  6.  PowerBuilder (Appeon)
Avory Rose Pastoral Avory Rose Pastoral
  1. PowerBuilder
SQL Parsing
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  John Fauss replied 5 years ago
1 reply
2352 views
0 votes
Hello, for simple SQL Parsing we have been using the PFC SQL Parser (pfc_n_cst_sql). Now we switched from Oracle Join Syntax (+) to ANSI Join Syntax (left outer join...). Is there already a parser that can handle this (preferably in Powerscript)? ...
  1.  PowerBuilder
  2.  SQL
Markus Schröder Markus Schröder
  1. PowerBuilder
Datawindow/Datastore - Insert/Update if exists problem
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Michael Kramer replied 5 years ago
4 replies
4974 views
0 votes
I have to modify exisiting data import function which works IN LOOP like:get data from text>  put into datastore  (via INSERT ROW(0) > update ( which causing insert into table....).my goal is to modify it to work like:add, new column - operationif op...
  1.  DataWindow
  2.  DataStore
Michał Misijuk Michał Misijuk
  1. PowerBuilder
Adobe OLE in Powerbuilder 2017 64 bit
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Vinay Batra replied 5 years ago
2 replies
3532 views
0 votes
Hi All We are in the process of migrating our application from PowerBuilder 11.5 to PowerBuilder 2017 64 bit. We have an OLE ActiveX Control on a window using "Adobe Acrobat DC Browser Control Implementation" Ole Object. Inprocserver32= …\Adobe\Acro...
  1.  64-bit
  2.  PDF
Vinay Batra Vinay Batra
  1. PowerBuilder
Google MAP inside OLE browser and get coordinates in PB code
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Saurabh Sharma replied 5 years ago
6 replies
3165 views
0 votes
Hi, I want to create an application which opens google map in embedded browser. When user clicks anywhere on the map, I need to get coordinates (longitude and latitude) of that location in PB code. I developed customer HTML with java script code fo...
  1.  Maps
Saurabh Sharma Saurabh Sharma
  1. PowerBuilder
Support Workspace Auto-Upgrade for IOS
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Kai Zhao @Appeon replied 5 years ago
3 replies
2059 views
0 votes
Hi, I have some doubts about how "Support Workspace Auto-Upgrade" works for IOS, if I set this section to "off" when creating a package as it appears in "Customizing and packaging Appeon Workspace" (https://www.appeon.com /support/documents/appeon_on...
arturo garza gonzalez arturo garza gonzalez
  1. PowerServer Mobile (Obsolete)
Android API 28 PowerServer Compatibility Update
  1. Resolved
  2. Misc
  1. Last updated 5 years ago
  2.  Kai Zhao @Appeon replied 5 years ago
2 replies
2590 views
0 votes
Hello, When is planned to be released the PowerServer update that will be compatible with the Android API 28? Last time I checked, the tentative release date was in August 31, but now I'm not sure about the new release date. Thank you
  1.  Android
  2.  Deployment
  3.  Play Store (Google)
  4.  PowerServer Mobile
Claudio Antonio Zaragoza Asomoza Claudio Antonio Zaragoza Asomoza
  1. PowerServer Mobile (Obsolete)
ERROR Google play
  1. Issue
  1. Last updated 5 years ago
  2.  Kai Zhao @Appeon replied 5 years ago
3 replies
2394 views
0 votes
Buenos días, Estoy trabajando con Appeon powerserver 2019 y  estoy publicando una app en google play. A la hora de publicarlo me devuelve el siguiente error: Requisitos del nivel de destino de la API a partir de agosto del 2019 Advertencia: Ac...
Javier Garcia Martin Javier Garcia Martin
  1. PowerServer Mobile (Obsolete)
How would you modify the code from the C# generator to create a multi-tenant web api?
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Sabir Foux replied 5 years ago
2 replies
2684 views
0 votes
This may be more of a question I can post on the dotnet forums but I wanted to asked for the expert opinion from the Appeon community first. Lets say I create a web api from my data windows using the C# generator. I want to have a database for each ...
  1.  .NET Core Framework
  2.  C#
  3.  Database
  4.  C# Model generator
  5.  Web API
Sabir Foux Sabir Foux
  1. SnapObjects
commit not calling the transaction sqlpreview event
  1. Advice
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
3 replies
2138 views
0 votes
Hi, i wanted to log commits and looked at the sqlpreview event. But it doesnt seem to be called by an commit - commit using tr; etc. I dont know if that is a bug or if it is intended to be like this. Does someone know?   Regards, Ferdinand  
Ferdinand Fischer Ferdinand Fischer
  1. PowerBuilder
switching from landscape to portrait unwanted
  1. How-to
  1. Last updated 5 years ago
  2.  Marco Meoni replied 5 years ago
3 replies
1788 views
0 votes
Hi Just build an app for our chainway. I turned off the automatic switch for portraid/landschape on the smartphone But the app (within the appeon workspace) still turns. How can I prefent this?   See pic
Systeembeheer SFR Systeembeheer SFR
  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