Discussions tagged DataWindow

PB 2019 R2 Build 2353 OS with problems: Windows Server 2008 R2 Standard, Service Pack 1 OS's that work fine: Windows 10 Enterprise and Windows Server 2012 Standard I recently upgraded an app from PB 12.5 to 2019 R2 and am seeing an issue with data...
Hello, I have a datawindow with column with Arabic characters, when I do dw.SaveAs PDF!, it looks like the arabic characters are changed its order in resulting .pdf file, however when I print the same dw on PDF printer - Arabic characters look the s...
Hi all, Thanks for spending your valuable time... I have an issue in the ItemChanged Event.  Consider that I have a dropdown data window having id genname in the list. The data type of id is numeric and genname is  string. The data column displa...
I am preparing for a Powerbuilder upgrade from 8.0 to 2019. I will be moving embedded sql to stored procedures and db functions. Is the sql in datawindows considered embedded sql and is it a good practice to move it to stored procedures and have the ...
I have a data window which I am saving as html.  In making some revisions to the application I have noticed a difference in the output html file.  The pre change version of the html has the title tag as titleOrder Inspectionstitle The post change v...
Hello,I have column "period", i set an editmask like ### to prevent enter a non-digits characters.When I clear this column (i expected null value in table) - there is always zero.What I want to achieve: column with numbers only and null - when null t...
Morning I hope you can help, I am trying to search / lookup records in a name field on a database. But i am having a problem with special letters  for example below - i want to be able to search 'Caus' and have the below show up ? so the special ch...
Hi All,Boolean operators AND, OR, and NOT have different precedence in DataWindow expressions than in PowerScript.Also, DataWindow expressions have SQL like operators that don't exist in PowerScript. I advise you always use parenthesis to avoid unde...
I am using datawindow control titles for the first time and I notice that I get a pale blue background and a fain almost unreadable text for the title.   Is there a way to change the color and or fond characteristics of a datawindow control's title?...
Ive been building a application that compares snapshots of tables, and have the code down to isolate the changes - now I need to highlight the background of the changed cells in a grid datawindow. I am flagging the changed columns by setting the ite...
I have a DataWindow Object on a Window that switches between two DataWindows via DataObject = "d_...".  Each DataWindow has at least one column with a Validation Expression.  I have no issues running the application in executable/desktop form.  Once...
I need to be able to set an attribute into a cell (row+column) in a grid datawindow which can be used to highlight or otherwise change the appearance of that cell by means of a datawindow expressions - and which can be read out by a program exporting...
I have an PB app that I am using metadata and modify to move columns and text around.  I am having two issues that I think I can work around if I can figure out one of two approaches.     1 - when I use the font.escapement property to rotate a colu...
I have a base window object w_parent that includes datawindow control dw_1.  I create a new window w_child that inherits from w_parent.  On w_child I assign datawindow object d_customer to datawindow control dw_1.  Also on w_child I insert a new data...
I have PB 2019 R2, I am trying to do as instructed https://docs.appeon.com/pb2019r2/pbug/ch20s03.html#Saving_as_PDF_using_xslfo and I get following error: ---------------------------Preview - dw_test---------------------------Save Rows As failed.jav...
Hello, In PB2017R3 when you do dw.SaveAs XLSX! an there is a cell with more than 32767 characters (character size limit of Ecel's cell) - resulting .xlsx file will consider this cell unreadable in MicroSoft Excel. At the same time Open Office just t...
Hi, hopefully someone can help I am getting an error in my application which is 32 bit pb2019 when i run it on windows 2016 RDS Error =  datawindow error Select Error: Decimal conversion error. Powerbuilder supports only 18 digits. Also on some ...
Hello,  I've built an infomaker page in an effort to display elements in the front end of gui system. Using a query and updating all fields to be no edit.  Code pulls a handful of elements from a series of joined tables with the where clause ..  s...
We have some code in our report-viewing window to determine whether VCR-like paging controls (for First, Previous, Next or Last Page) are enabled based on whether there are multiple pages. However, one of our reports has grouping, with Group 1 havin...
Hello everybody, I have a mobile application for Android and I have a problem displaying images in a datawindow object with a tableblob object, when I'm designing the datawindow object in the preview, the images show fine, but when I deploy the app a...

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