Discussions tagged Data

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. ...
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...
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...
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 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    ...
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...
Hi, Where and how can I track DBError of SQLCA transaction object when I'm using Datastore? In Datawindow there is dberror event but how to do it with datastores? BR, Hannu   ...
Hi, Could someone advice me how to access JSON-data in deeper levels, for example street and area in this example data. I'm able to read upper level like location and formatted_address but how to access child data of address_components? { ...
  • Page :
  • 1