for simple SQL Parsing we have been using the PFC SQL Parser (pfc_n_cst_sql).
Now we switched from Oracle Join Syntax (+) to ANSI Join Syntax (left outer join...).
Is there already a parser that can handle this (preferably in Powerscript)?
is there a tool to check the sql in all Datawindows in a workspace against the database?
We are migrating a huge project from Oracle to Postgres (sql join syntax has changed from (+) to "left outer join"). In some of the existing Datawindows...
Thanks for the people who helped me to get the issue resolved for my previous post.
lds_data = Create DataStore
lds_data.dataobject = 'd_revoke_certificate_hhg'lds_data.SetTransObject(SQLCA)
ll_total_rows = lds_data.R...
I am using PB 2017 R2 and SQL Server 2017. The following test code works when running on a desktop. When running on a mobile device (iPad) I get error "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION."-------------------------...
How can I distribute the free SQL Anywhere with my PB app. I used to use dbeng50.exe but it has gotten buggy in Windows 10. I have read that you cant use dbeng* and need to use rteng* but I can't find it anywhere.
We have a pfc based Powerbuilder 12.6 app using SQL Anywhere that we are starting its migration to PB 2017.
We handle international film distribution and some of our customers want to be able to enter the local European language names - but our c...
any way to get the values i can put in the Powerserver Datasource for MSSQL Server in the
Other Options and Extended Options
if i put the same than the dbparm seems to have no effect.
for example i have in my DBPARM:
This is tech team of Citi Bank Korea.
A couple of KR team's applications have been using the PowerBuilder 12.5 as a client development tool.
Vulnerability Assessment team found some issues that DB password is shown in PC memory ...
Is there a way to have PB execute Embedded SQL or Datawindow queries in a parametrized form? (Apart from rebuilding the entire application to use Stored Procedures)
We have a (embedded or DW) SQL query like this:
SELECT col1, col2
Recently our company we have upgraded desktop system fron windows 7 to windows 10, post that when ever large calculation runs on Powerbuilder application it is showing update fail intermediately and shows error in datawindow as connection was ...
Got a trace from a customer from a SyntaxFromSQL:
(23b7008): Select (...)
(23b7008): GET EXTENDED ATTRIBUTES: TABLE=tablename OWNER=dbo (16 MilliSeconds)
Error 208 (rc -1) : Name of Object 'dbo.pbcattbl' in...
I just converted a power builder 9 app that connects to an "MSS Microsoft SQL Server" DB to power builder 2017 and now when i go to run the app it throws an error
"DBMS MSS Microsoft SQL Server is not supported in your current installat...
I have a PB app that was written long ago, and one thing it does is build its (MySQL) database as needed. To do this, all of the scripts needed to build the database were added to function objects, one per database object. i.e., there's an "fn_...
I want to know performance related result for Commit command which we are using inside PowerBuilder and Backend is SQL Anywhere 16 & Isolation Level used 'RU'
1. If I use commit script for each row, what is the performance impact?
Same with Title.
This mistake that made me so battered.
li_rc = inv_luw.of_Update(apo_control, ab_accepttext, ab_resetflag)
messagebox('of_update', sqlca.sqlerrtext) //sqlerrtext return ""
We just converted our databases to MS SQL 2014. I've been using Infomaker as a database tool for over 15 years. When I open a table, the insert, delete, and update buttons are all highlighted and work as I'm used to. If I do a search fir...
I'm comparing 10.5 and 2017, trying to get the backing to move to 2017. I've come across an interesting issue that has me stumped.
Basically we have the following code
DECLARE OKButtonOnlyForm PROCEDURE FOR SYSADM.p_OKButtonOnlyF...
I work for a small financial services company, We have our own suite of desktop client server applications (not web based) that we developed ourselves (c#/ Java/ Powerbuilder frontend, SQL Server backend).
Apologies for clueless sounding que...