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
22111 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
5347 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
TIP: Open each post in this forum with "Open link in new tab"
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Armeen Mazda @Appeon replied 6 years ago
2 replies
1991 views
0 votes
Im sure that everybody that uses this forum, and quite possibly their dog as well, have figured this out, but JUST IN CASE.... The best way to read the posts in this forum is to open each post in a new tab. Right-click the mouses and select "Open ...
Olan Knight Olan Knight
  1. PowerBuilder
Does anyone had issue with longlong datatype in PB170?
  1. Issue
  1. Last updated 6 years ago
  2.  Hung Doan replied 6 years ago
5 replies
2796 views
0 votes
Does anyone had issue with longlong datatype in PB170?  This codes work with PB125 but now I find out it does not work with PB170 R2. I defined a variable longlong al_unos_race, read in a longlong as you can see from the first screenshot below.  B...
  1.  LONGLONG
Hung Doan Hung Doan
  1. PowerBuilder
How to Dynamically Change Currency Column Format
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Glenn Barber replied 6 years ago
7 replies
3572 views
0 votes
We have reports where the currency value needs to be displayed with the appropriate currency symbol.  We can provide each row with the currency code and the currency symbol. How do we construct a dynamic format  The Base format is #,##0 ;[RED](...
  1.  Data
Glenn Barber Glenn Barber
  1. PowerBuilder
MSSQL State Error 42S02 "native client invalid object name
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
3 replies
5539 views
0 votes
I am currently using the 30 free trial of Powerbuilder 2017 R2 I just migrated some old pbl files and testing the intial connection to MS SQL server I changed my DB parameters from MSS to SNC (i have the native clients installed successfully) when...
  1.  Client
Samir Patel Samir Patel
  1. PowerBuilder
Can we install 2017 PBVM on Windows Server Core 2008
  1. Issue
  1. Last updated 6 years ago
  2.  Roland Smith replied 6 years ago
2 replies
2493 views
0 votes
Hi Experts, We are in such a situation and have to install 2017 PBVM s in order to compile/regenerate the PB object to pbl hence, we need to install both PBVM and PowerGen on windows core server Can anybody share their experience or is this fea...
  1.  Build
  2.  Server
Ibrahim Syed Ibrahim Syed
  1. PowerBuilder
Error using PB .Net Assembly in Server
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Mariano Recuero replied 6 years ago
4 replies
2831 views
0 votes
Powerbuilder 12.5 Classic hi, i got a PB classinc .Net Assenbly that generate a pdf file from a dataStore. This Assembly is added as reference in a ASP.NET MVC 4 web application. In my PC with IIS Express (from VS 2012) it works perfectly...
  1.  .NET Assembly
Mariano Recuero Mariano Recuero
  1. PowerBuilder
TX Textcontrol X14 - RTE trouble
  1. Issue
  1. Last updated 6 years ago
  2.  Richard Shakour replied 6 years ago
2 replies
2343 views
0 votes
Is there anybody who uses the 3rd party RTE control in Powerbuilder 2017? We got a trial version of this control from the manufacturer and we are currently evaluating the control. Now we see some oddities: * Modifications to the content of the ...
  1.  Text
Martin Eberle Martin Eberle
  1. PowerBuilder
error in db
  1. Issue
  1. Last updated 6 years ago
  2.  Olan Knight replied 6 years ago
2 replies
2053 views
0 votes
hi Everyone, I am having database error in the below piece of code. IF SQLCA.SQLCODE <> 0 THEN    //If an error: notify the user    MessageBox("Database Error!", "Error while saving data to the database. Error message: [" +STRING(SQLCA.SQ...
  1.  Build
radha rani radha rani
  1. PowerBuilder
PowerServer application logon windows customization
  1. Issue
  1. Last updated 6 years ago
  2.  mike S replied 6 years ago
1 reply
1812 views
0 votes
Hello All, If i set the User Authentication setting to security on when the user open the application Powerserver display a logon window. the question if this logon window can be customized for example add some image. Thanks in advance 
  1.  PowerServer
Andres Slachevsky Andres Slachevsky
  1. PowerServer 2020 or older (Obsolete)
Different WIN.INI loaded in AEM while deploying INI
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
2 replies
2067 views
0 votes
HI Team, When I select WIN.INI in PowerServer Toolkit Configuration, same WIN.INI is not loaded in AEM.  I can see below WIN.INI content in AEM INI Files.    [aedebug] [clock] [colors] activeborder=180 180 180 activetitle=153 180 209 ...
  1.  Build
Devang Modi Devang Modi
  1. PowerBuilder
PB 2017 Version of pbejbclient126.pbd
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
3 replies
2458 views
0 votes
Dear Appeon Powerbuilder Community Members, The Powerbuilder 12.6 client I support uses pbejbclient126.pbd which is located in c:\Program Files (x86)\sybase\shared\powerbuilder.  I have installed a trial copy of Powerbuilder 2017 R2 which does not...
  1.  Build
Louis Marchand Louis Marchand
  1. PowerBuilder
opensheet throw runtime error
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
2 replies
1975 views
0 votes
I use opensheet() but occasionally throw runtime errors. Closing the program and turned on, its executed normally. ↓↓↓ My code: ↓↓↓ string ls_prog w_sheet lw_prog ls_prog = "w_prog" try     Opensheet(lw_prog, ls_prog, frame, 0, Ori...
  1.  PowerBuilder
Li Mei Weng Li Mei Weng
  1. PowerBuilder
Error creating a pdf file from webservice
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
2658 views
0 votes
Hi, I have created a webservice from PB 12.5 Classic. Webservice got a function that receive some parameters, retrieve data from DB in a datastore and then save ds as a pdf file (in C:\temp\PDFs\) and then return name and path of file created. ...
  1.  Build
Mariano Recuero Mariano Recuero
  1. PowerBuilder
Splitting data window in multiple pages
  1. Issue
  1. Last updated 6 years ago
  2.  Lars Mosegaard replied 6 years ago
2 replies
2714 views
0 votes
Hi, I have a scenario where I wanted to split the input fields of data window in multiple pages. For example if I am opening the data window first few columns should displayed then when I click on next rest of the columns should be displayed an...
  1.  Data
Shaila Panwar Shaila Panwar
  1. PowerBuilder
BackGroundColor of Column in Datawindow while running on Appeon Web
  1. Issue
  1. Last updated 6 years ago
  2.  Lars Mosegaard replied 6 years ago
2 replies
2644 views
0 votes
Hi Techies,   When we run application on Web (IE) during running if we disable column s background color is not taking effect. still its remain as black.   Do we need to handle it differently?   Thanks & Regards, Devang Modi.
  1.  Build
Devang Modi Devang Modi
  1. PowerBuilder
How to capture Datastore UPDATE error ?
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Michael Kramer replied 6 years ago
2 replies
5021 views
0 votes
Is there a way to capture SQL error when run datastore.update() return -1? For some reason SQLCA.SQLCode and SQLErrorText are empty  when ds failed to Insert or Update a row. Thanks, Yuri
  1.  Data
Yuri Denshchik Yuri Denshchik
  1. PowerBuilder
mailLogon failing on shared desktop
  1. Issue
  1. Last updated 6 years ago
  2.  John Fauss replied 6 years ago
2 replies
2524 views
0 votes
Hi all, Hoping someones run into this issue and knows the fix...sending emails using PB 12.6 and everything works fine, except when on a shared desktop, where code fails calling mailLogon and the program crashes. Any help would be greatly appre...
  1.  Email
Randolph Fung-A-Fat Randolph Fung-A-Fat
  1. PowerBuilder
Data entry form creation
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
2 replies
2143 views
0 votes
Hi Everyone,   I want to create a data entry form in powerbuilder in which user will enter their data and it gets saved to database. how to create it.Please give me a idea of creation  
  1.  Build
radha rani radha rani
  1. PowerBuilder
Question about Bitmap() function
  1. Issue
  1. Last updated 6 years ago
  2.  Roland Smith replied 6 years ago
1 reply
2620 views
0 votes
Hi, We wide use Bitmap() dw function in the computed fields of our data-driven DWs. The display images can be stored as external files or as internal resources in PBD(s). In special case I want to display a specific image if the given source file ...
  1.  PowerBuilder
Alexander Strelkov Alexander Strelkov
  1. PowerBuilder
Can you use .js files in powerbuilder
  1. Issue
  1. Last updated 6 years ago
  2.  Marco Meoni replied 6 years ago
1 reply
3917 views
0 votes
Hi , Can I use external .js files in pb ?   Regards   Devesh    
  1.  File
Devesh Bhatia Devesh Bhatia
  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