Discussions tagged DataWindow

Is there a way of protecting  a specific column in a DW by referencing by row, e.g. I want to input to column A in 1st row, but disable A in 2nd, Modify does not allow row to be used, so end up disabling all rows. Does not seem to work in Datawindow...
Hi, I have a report as below. I would like to automatically add number in each group header in No. X where X will be 1,2,3,4.etc...Is this possible? Regards,Marcin...
I am trying to create a new data window by sourcing an Oracle Stored procedure. The stored procedure has compiled and been tested using Oracle SQL Developer. It runs fine. However when i try to create a data window it throws a Date Error before i can...
I have a report that has the detail band and columns set to autosize their heights. The issue I am having is the last row is cutting off the text in a column that works fine in other rows. I need it to display properly for all rows. See the screensh...
Hello, is it possible to generate a fillable PDF form (DW save as PDF, PowerBuilder 2017 R2)? The customer wants to fill out fields in a PDF form and save it. Thanks for answering  ...
With PB 2017 new feature of saving datawindow to PDF is causing application to crash when datawindow contains jpgs (photos). But not all for some photos it works fine. And it is not consistent with size of the photo either. The application is a cl...
I did a filter on some names, some of which started with "A" or other capital letters, and some of which started with "a", where the filter expression was: name > 'a' It selected all of those names. If that was case sensitive, like I thought DW exp...
Hi.   One of our customers have almost only 4K monitors in their organization. They run our PB 2017 R3 application via RDP and/or Remote Apps (Work Resources) in Windows 10. They report that they're experiencing very sluggish performance in almos...
Hi Can anyone tell me what i am doing wrong I have a Rte control - that has text, text fields and numeric fields on it - i copy this to my datawindow the text fields display the data but the numeric fields just show a blank space. The fields match...
Hello, I have a char(2000) column in a datawindow that uses the EditMask edit style with an edit mask of 2000 'X's. However, I cannot enter more than 255 characters in it. I tried this in PB12.5 and PB17r3. I could not find any information about a l...
As per someone's advice here I'm using the StripRTF() datawindow function to display plain text values from a RichText source. This works fine in my development environment, but in a deployed application this column is blank. I immediately thought th...
Is it possible to display only un-formatted text that has been stored as RichText in a database? I thought there might be some control or datawindow function that would strip off the formatting but I'm not seeing it....
Hi This is Prashant here I am facing probem with unicode numeric datatype. Which I believe could be for numeric values unicode \u and I set Edit mask Format = ###,###. If I removed Edit Mask and allow it return garbage value. If fails to enter nume...
Hello, PB 2017 R3, build 1880, Posgresql 11.1 Calling a function from itemchanged event, which retrieves value from db through a query,  Select a.nameInto   :ls_nameFrom  table_aWhere field1 = :ls_where; Messagebox('return1', sqlca.sqlcode)Messag...
We have a DW report with a Summary section with height 0 but autosize height, which can be varying heights depending on the data. We have found that PB tries to always keep the Summary section together on one page, but will never put it alone on the...
With the new theming UI in beta, do we have the capability to make a checkbox and/or radiobutton look disabled in a datawindow like we can on a regular object? I have a screenshot below of what I mean outside of a datawindow.     I don't want to...
I'm using Powerbuilder 12.5. In design mode I have expression on protected which is working how is intend. When i run application is not working at all. Any help please....
Hello, Using PB 2017 SP3 Build 1880 [in a computed column in a datawindow] I need to display a computed column with amount in Indian Format [ ##,##,##,##0.00 ]   (See the comma).  When I create the expression as  namecolumn + ' (' + String(groupb...
Hi Guru I have a problem with an application that crashes. Ecosystem: Windows server 2012r2 Oracle 10 Powerbuilder 2017r3 When I retrieve a datawindows the system goes into error. The retrieve should recover 3,137,457 records. Thi...
Hi All,   I'm using PB12.1. I create a datawindow using syntaxfromsql and then add some controls dynamically into it. All is working except that when I want to modify the width expression of one the controls I added, I could not get any success. Ca...

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