Featured Questions
Q&A Forum Tip: Including Source Code in Your Question
- Advice
- Last updated 3 years ago
- Tjafzfa Gsjsf replied 8 months 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 3 years ago
- Olan Knight replied 3 years ago
Saw this and thought it was perfect. Note the angry mob in the background on panel 4. :)
Opened Transaction on SQLSERVER without DML commands
- Issue
- Last updated 10 months ago
- Aquitetura Corporativa Unicred replied 10 months ago
Hello all,
We are using Powerbuilder 2019 with SqlServer 2016 and we noticed that when connect to the database the application is always starting a new transaction (without any insert/delete or update)
if we execute the following select:
select...
Application crash due to PBSHR.dll
- Issue
- Last updated 10 months ago
- Chris Pollach @Appeon replied 10 months ago
Team,
we are in PowerBuilder 2022 Build 1900, Windows Server 2019
in some particular cases, we have a system error, while trying to print some PB reports from our PB application.
Event viewer logs are attached.
Sql Server - Row changed between retrieve and update
- Advice
- Last updated 10 months ago
- mike S replied 10 months ago
Sql Server 2019
PowerBuilder 2019 R3 build 2728
I'm using ODBC connection
I have a datastore, I change data and then do an update
lds_post_dates.setitem(i, "column_name", ll_value)ll_rv = lds_post_dates.update()
The base table for the datas...
reading from the registry to connect to the db
- How-to
- Last updated 1 year ago
- Albert van Bochove replied 10 months ago
Hello,
in my application I am connecting to the database using the connection string that is defined in a Registry key, this is my code and as I show you in the attached images, you can see that when I debug my code I am receiving my transaction all...
datawindow button.Background.Color with themes: theme-customs.json
- Resolved
- How-to
- Last updated 10 months ago
- Ronnie Po replied 10 months ago
Hi All.
Appeon PB 2019 R2
I am trying to change datawindow button control ( b_1 ) background to red in the datawindow ( dw_1 ) in the window ( w_test ) using theme-customs.json
{"meta-info": {"version": "190"},"w_test.dw_1.b_1": {"drawing": true,...
duplicated primary key error even tho it dosent exist
- Issue
- Last updated 10 months ago
- Berka Frenfert replied 10 months ago
hello everyone here
in my powerbuilder 19 project, it's about article management. so when i insert a new article it works fine and when I update an article it works fine also but when I insert another article (after the update), i get the sqlstate e...
how can i get a message box for duplicated primary key before submitting the form
- How-to
- Last updated 10 months ago
- Berka Frenfert replied 10 months ago
in my powerbuilder 19 project, i have a DB called "gest_article" and a column "reference" set as a primary key and unique value, and a data window called "dwc_article" is a freeform to insert an article.
i wanna get a message box for duplicated refe...
SBOM form PowerBuilder Application
- How-to
- Last updated 10 months ago
- Armeen Mazda @Appeon replied 10 months ago
Hi Team,
We've been asked to generate a Software Bill of Materials regarding our PowerBuilder based application.
Any option there to generate this information from PowerBuilder. Is there any tools to generate this information? We are currentl...
Snapdevelop Error to Publish
- How-to
- Last updated 10 months ago
- Armeen Mazda @Appeon replied 10 months ago
When I try to publish it sends permissions error, how can I fix it?
Please launch SnapDevelop under administrator mode to perform this deployment action
The login user I am using is the administrator of the computer.
GreetingsRenaul
Web Api Tester starts but closes immediately
- Issue
- Last updated 10 months ago
- Riccardo Pasqualetti replied 10 months ago
HI,if I try to debug my service, Web Api Tester starts but closes immediately. The Snap Developer version is old but has always worked. Here is the console output:
Web API Tester-The test service has started and is listening on port 65533.Host- i...
Custom Colors, Where stored in the Registry?
- Misc
- Last updated 10 months ago
- Matt Balent replied 10 months ago
I'm getting ready to upgrade my work laptop. Where in the registry are the custom color settings in PB stored? (registry way too big to search manually)
Thanks
Matt
SQL Anywhere 16+ Default DB Owner for alternate user
- How-to
- Last updated 10 months ago
- Ronnie Po replied 10 months ago
If App_user is created to connect to SQL Anywhere that is other than DBA, granted Select on the tables, how can the table owner default to DBA without explicitly using DBA.my_table? We don't want to use the DBA account for the application.I've tried ...
Hi,
I'm trying to connect PB to GitLab repository, but failing with error "Cannot connect to the repository. Please make sure you have specified the correct user ID and password".Which I think as I can log into GitLab using a browser using those cre...
Can Powerserver/CAL install .Net runtime on Client's PC
- Resolved
- Advice
- Last updated 10 months ago
- Anoop Chaurasia replied 10 months ago
My Application have multiple .net DLLs which is built using .net 2 and 4.
While launching the powerserver application it is throwing error on client's PC when .net runtime is not available. Is there a way to check the .net runtime and install on cli...
Deployment on clean computer crashes
- Issue
- Last updated 10 months ago
- Ken Guo @Appeon replied 10 months ago
Upgrading a PB 12.5 app to PB 2022R3. Uses ADO.NET to connect to SQL Server. App crashes during connection process (i.e., after credentials are entered and Login button is clicked) on a Windows 11 machine.
Faulting application name: xxx.exe, versio...
SMTPClient Object - read confirmation
- Resolved
- How-to
- Last updated 10 months ago
- Andreas Mykonios replied 10 months ago
Hi
I'm trying SMtpClient in Powerbuilder 2022 R2. There are many new features to use like encodig,logfile,setproxy and xoauth2AccessToken.
it's working amazing!!
But just to try to maintain the above functionality, is there a way to get opened ema...
Hi
I am converting the old 'web service proxy' calls to the new 'httpclient'.I'm running the directions in 'https://www.appeon.com/developers/get-help/knowledgebase/call-soap-web-service-using-httpclient-object.html', but it doesn't work. (performed...
datawindow button.Background.Color with themes
- How-to
- Last updated 2 years ago
- Tomas Beran replied 10 months ago
Hi
Is there a way how to force a different button color from code if a theme is applied?
The only working method I've found is to disable theme for the button with
"drawing":false
But what I want is to use the theme and only override it progra...
I'm looking to automatically kill a process if it gets over a certain CPU percentage. I need to know what API function to call to get the CPU percent.
I already know how to get a list of processes.
When saving a web browser control image File path inquiry
- How-to
- Last updated 10 months ago
- Chris Pollach @Appeon replied 10 months ago
Right mouse button in PowerBuilder webrowser controlClick and save photo under a different name.Even if you save the desktop by specifying a path,You will still see it in the Downloads folder.Do I need to make other settings?Just save the photo under...
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
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