Featured Questions

A recent post included some PowerScript code, and I thought I would pass along a tip for pasting code snippets that produces a slightly more readable result than simply pasting code into the website's text editor. The toolbar contains a button to as...
Saw this and thought it was perfect. Note the angry mob in the background on panel 4.   :) ...
Hello, I was wondering if anyone knows how much column datatypes of datawindow objects must match in order for RowsCopy() to work. For example, are "number" and "decimal" compatible? Or "char(10)" and "char(100)"? "Date" and "datetime"? Unfortunatel...
After a server crash the Powerserver license become invalid, so the server is not available the time to get a new license file. What could we do to avoid this ?...
Hi, I have a new problem with PowerServer Mobile x SQLite3 numeric datatype columns on local database. The table has numeric(10,4) datatype columns. When I type the values they are saved corretcly (10,4), but when I retrieve the same data from table...
Good Morning! I have an issue: PowerBuilder is calling the APD functions with an open transaction. => The APD functions are Stored Procedure(s). ( we can not have access to see how these SPs are coded )  => Our PB application calls these APD...
Hi, Gurus I have this weird problem. I have a datawindow where I cannot open the data source. I have discovered the culprit but I don’t know why. In the SQL field list have a group_concat SELECT ….., group_concat(maillistdesc.descr separator ', ...
We always used the SQL Server ODBC driver for connection. However, SQL Server data are not accepted on servers that doesn't allow SSL 1.0. Therefore we want to use other drivers ({SQL Server Native Client 11.0} or {ODBC Driver 13 for SQL Server} or...
PB 2017 R3 build 1858  32 bit application I have been doing a lot of web client refactoring lately, using JSON. I some instances I send and receive huge JSON return data sets, of a complex, nested  nature and containing base64 encoded images. One ...
Hi All, The result set return by the datastore is a JSON format which is different when compared with the JSON string returned by the datastore.ExportPlainJson built in method: teh column names are surrounded by the back slash character \ Example i...
Hopefully this is an easy one !   I am sure there is documentation on this but i cannot find it. I am trying to run my new web app on chrome - it runs fine on several machines but fails on one. I open the page, it downloads the browser plug in - ...
Hi, I would like to know what are the options below the function DataStore.Retrieve(arg[]) method, can I use any passing argument to get only the first 50 values ? Regards, ...
I just figured out that if you do GetEnvironment(env) and then examine env.ScreenHeight and env.ScreenWidth, they do NOT show you current screen dimensions, unless you have the text etc. scaling set to 100%. If you have it set to 125%, for instance, ...
Is it possible to completely hide the menu in a MDI application. I believe I can loop through all the items at top and hide each of these, but I wonder if there is an easier way, does anyone know? I want to toggle so that users can switch menu on a...
when doing a full build is there a way to log output to a file?  i have 2 apps with common objects.  i compile APP1 and move PBD's to a common folder.  when i compile APP2, which has PBD's in the common folder, the pbl's compile as expected.  when PB...
Hi all ,   I want to print a dw but  - with out the header repeat itself in each page . I went on the idea of getting the pagecount() of the dw , and maybe try  to minimize header.height by Describe in run time just for the next pages ( I want th...
This is in PB2019. The Help doesn't say, and I don't have a copy of Windows 8 to try it on. Thanks....
Hello,I use Appeon PowerBuilder 2019.Does anyone have an example of simple use of Web Services with this tool? I tried the following example:Call SOAP Web Services Using HTTPClient ObjectBut that doesn't work for me. Thank you very much....
Good morning   I'm doing tests on how to convert a ns. application that works on Oracle to PostgreSQL. In particular, I am checking the following settings:     What is the difference between: ANSI, ANSI_ESCAPE. PB ?   Example in PostGreSQL:...
Why are there two products listed for powerserver bugs?  There should only be one!  The powerserver (PB Edition) is the same product as powerserver, it just has a different license.  If you are looking to see if anyone else submitted a bug, you have...
Our flagship PB Classic desktop application relies more and more on COM InterOp bridged .NET functionality.  Our bi-monthly release cycle includes changes to both PB and associated .NET code  We formerly deployed .NET code into the GAC.  But when kee...
I am trying to using the Appeon training material and need to use the trial version of SQL anywhere , but there is only one option for trial version and it is 17.0.4.2053 which is incompatible with PB 19 as per message that I get which says "SQL vers...


There are no discussions available here currently