I insert a row in a datawindow, the the datawindow is updated (dw_1.update()). When a commit is triggered in my script no data is inserted in the database and I got no error.
The same code works fine for Oracle database.
dw_rowcount() = 1
PB 2019 R3, PostgreSQL 11
While querying the PostgreSQL database, with the following query
SELECT username, application_name, client_hostnameFROM pg_stat_activity WHERE datname = 'database' And state = 'active' ;
I get empty in application...
Need to connect to a web PostgreSQL database from a PB application, to run DDL statements. Our configuration of pg_hba.conf allows connection from localhost only. I can connect to that database from PGAdmin by configuring SSL Tunnel.
Powerbuilder 2019 R3, Postgresql 11
I want to trigger a function in Powerbuilder (to print, actually) whenever there is an insert of data in a particular table with a particular value in a field. Is it possible ?
Billing data w...
We are using PB2017R3 against Postgresql version 10 using ODBC driver.
We have a bug where an error message of over 320 chars is being truncated to 255 characters.
Is there a limit set somewhere that can be adjusted please?
Hi,I want to connect my powerbuilder application to PostGres, Is there any native PostGres driver or should I connect via ODBC/JDBC driver?Right now, I could connect the database painter using ODBC driver.
Env: PB 2017 R3, postgres v13 64 bit server, ODBC driver 32bit v13
Hello Experts - We are exploring postgresql as our option as we are trying to move away from sql anywhere.
Would like to get your thoughts on what i am missing or how to go about fi...
I have code that i need to use dynamic cursors for to scan for key values in referential testing.
database is postgres.
the first query must be in sql as the compiler does not recognize the @ character as SQL. it works fine.
the second query canno...
I have carefully followed Bruce Armstrong' tutorial for connecting PowerBuilder 2017 R2 to PostgreSQL, but I have a trial version of Powerbuilder 2019 R2 which I am trying to connect to a PostgreSQL 10 database. So far, I have not been success...
I'm am testing PostGreSQL and I piped a bunch of tables with no problems but when I tried to update the data I got an error on any table that already existed. If I drop the table first it works fine.
Pipe Error -17 SQLCode = 1 SQLSTATE = 42P01
we are migrating a powerbuilder 2019 project from Oracle to Postgres 12.
The async database parameter is set to 1 and the retrieverow event is coded, so i can cancel a retrieve.When i am connected to Oracle (native driver), everything works ...
Using PB 2017 R3, Postgresql 11.6
By using the query
Select a.itemcode as code, a.value as value, a.itemname as name, a.version as versionFrom tablex aUnion All
Select '' as codem, 0 as value, b.name as name, '001' as versionFrom tabley ...
we are migrating a PowerBuilder project from Oracle to Postgres.
In Oracle a multiline text in a datawindows is saved correctly (with chr(13), chr(10)). In Postgres (version 12 with odbc driver) the carriage return, line feed is replaced wit...
PB 2017 R3, PostgreSQL 11.1
Looks like PB doesn't report an error when there is a violation of uniquess in a table, instead it goes into a infinite loop. Uniqueness created with a unique index and NOT primary key.
Removing the unique inde...
PB 2019 Build 2082 using PostgreSQL 10.8
We have a problem reading values from column that is text data type with a length over 32768 characters. If the length of text is bigger we get only first 32768 characters
We configure ODBC for database ...
i am migrating a PowerBuilder 2019 Application from Oracle to Postgres.
When i am connected to Oracle, i call the following procedurePROCEDURE p_proc(aol_error_nr OUT NUMBER, aos_error_text OUT VARCHAR2)
in this way:
DECLARE dbp_Proc PROCE...
Need to execute 'update .... ' statement, when data found while 'inserting data...', from datawindow
PB 2017, Postgresql 10.
Giving facility to import records from XML and Excel. While importing records, few records might already available...
PB 2017 R3
When connecting to Postgresql, table names are not schema qualified. PB assumes the user that I am connecting with, is the schema / owner of all tables.
I have confirme...
Using PB 11.5, PostgreSQL 10
When showing error while updating dw / ds, it shows ? in places of field values. It would be better if values are shown, to identify and correct those values. We used to see values while using SQL Server, but ...
I'm having an issue where opening any datawindow in the powerbuilder IDE will turn on ODBC database logging causing application testing to run extremely slowly. Logging is not turned on in the ODBC DSN or in the properties of the connection in th...