Discussions tagged Data
Hi,
I am trying to load up a text file which contains special characters
an example of the line i am loading is
54743 ALG00006 Chemloul Associés
when i load it using the code
integer li_FileNumstring ls_textboolean lb_stop
messagebox("wi...
Composite Datawindow Report
- Resolved
- How-to
Hello all,
I am trying to build a report through composite data window and my child data windows have different retrieval arguments (one is bounded by date whereas the other one is a list of all items). What I need to do is display the pieces of the...
In SQL, We have option for On Existing Update or skip where as in Datawindow, we need to first find and take action. If ON EXISTING UPDATE or ON EXISTING SKIP properties, then lot of script writing can be avoided.
...
Data store
- Resolved
- Issue
Hi,
i want to cache a table which is used to retrieve dropdown values. So i want to reduce the full scan, so caching the table and retrieving from it will improve the time. How to cache the table ? Please help.
...
Hi
I have a requirement where I will need upto 150 N-Up dataObjects eg 1 - 150 columns to be available at runtime
so that I can switch to the appropriate DataObject based on a selection by the end user.
I know I could do this by Hand which I...
Looking for some input as to what exactly this setting does and why you would not always just set it to Large? I have customers that run into an issue where if the report is too large it will just crash because it has exceeded the memory. I am wonde...
Pasting text into EditMask Column
- Resolved
- Issue
Hi
Ive got a Datawindow Column (of type string(9)) with an EditMask of ###-###-###.
If I paste the string 123456789 into this field, I get this:
Am I doing something wrong or is an EditMask just not suited for Copy&Paste?
Regards,
...
Rowid filter
- Resolved
- Issue
Is there a way to filter on the raw datawindow rowid? I dont want the row number because it changes when you sort etc. I know you can get the rowid by using GetRowFromRowId, but i would like to have a simple filter like this: rowid in (1,5,7,9,25). I...
Hello All,
Regarding .SaveAs :: The datawindow engine handles opening, writing and closing the file. I have yet to find any documentation about fileaccess & filemode
I would “guess” fileaccess is Write-only and filemode is lock-write. Bu...
querymode
- Resolved
- Issue
Hi All,
Hopefully you can help, where do i find any documentation on using a datawindow in querymode - I know how to put it into querymode - add do simple query
What i mean is i can do for example ( when a date field )
how would you do for...
++ PB 2017 R2
Hello all,
I am writing a script to take in a PSR file, then Save As PDF. It seems the conversion to PDF does not automatically determine portrait/landscape. Im playing with code to figure that out.
ISSUE: I have many...
Hi,
In Powerbuilder we have a amount field with following properties -
Editmask set as #######.00
Format set as #,##0.00;-#,##0.00;0.00;
By default when control reaches to this field and any amount entered is entered on the left of the decim...
Is there a datawindow expression that can be used to get the actual row id of a row. Similar to GetRowIDFromRow function.
Follow-up, thanks for every ones ideas. I was trying to avoid adding a column just to keep track of a specific row. R...
Powerbuilder2017R2 successfully installed on a Windows Server 2016 Datacenter virtual machine. This is a newly created virtual machine.
This is from the event viewer showing Powerbuiilder successfully installed:
"Windows Installer installed th...
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](...
Hi
I work to Powerbuilder 2017R2 i having a problems with my datawindows, when i open datawindows the powerbuilder close. Someone have this problem please help.
thank
...
How to capture Datastore UPDATE error ?
- Resolved
- Issue
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
...
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...
Can we create Data window dynamically from XML in PB17.
The XML can vary hence each time it could have deferent number of elements.
Please share any example if it can be done.
...
Can anyone tell me is it possible to have a composite datawindow with sub reports ( i think thats what they are called ) - connecting to different databases ?
My app has SQLCA and then another transaction objec SQLCR - I want to add a subreport th...
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