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
messagebo...
Composite Datawindow Report
- Resolved
- How-to
- Last updated 5 years ago
- Olan Knight replied 5 years ago
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...
NEW FEATURE REQUEST - DATAWINDOW UPDATE PROPERTY
- Issue
- Last updated 6 years ago
- mike S replied 2 years ago
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.
...
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.
...
Dynamically Creating Multiple N-Up Datawindow Objects
- Resolved
- Issue
- Last updated 6 years ago
- René Ullrich replied 6 years ago
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
- Last updated 6 years ago
- Govinda Lopez @Appeon replied 6 years ago
Hi
I've 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...
Is there a way to filter on the raw datawindow rowid? I don't 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,2...
Datawindow SaveAs locking mode
- Issue
- Last updated 6 years ago
- Chris Pollach @Appeon replied 6 years ago
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...
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 ) ...
++ 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. I'm playing with code to figure that out.
ISSUE: I have...
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...
Is there a Datawindow expression to get actual row ID
- Issue
- Last updated 6 years ago
- Lars Mosegaard replied 6 years ago
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 installs but does not run on Windows Server 2016
- Issue
- Last updated 6 years ago
- Chris Pollach @Appeon replied 5 years ago
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...
How to Dynamically Change Currency Column Format
- Resolved
- Issue
- Last updated 6 years ago
- Glenn Barber replied 6 years ago
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
- Last updated 6 years ago
- Michael Kramer replied 6 years ago
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
...
Splitting data window in multiple pages
- Issue
- Last updated 6 years ago
- Lars Mosegaard replied 6 years ago
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...
Creating data window Dynamically from XML
- Issue
- Last updated 6 years ago
- Alexander Strelkov replied 6 years ago
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.
...
composite datawindows - multiple odbc connection
- Issue
- Last updated 6 years ago
- Govinda Lopez @Appeon replied 6 years ago
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...
- Page :
- 1