Discussions tagged SQL
When querying using query mode when connected to Oracle 19c, and the column being queried has an alias, the oracle statement looks like this.
(AND table.column aliase = 'Input data' )
Example:
In the select part:
COMPANY.STATUS COMPANY_STATUS
P...
I like to log the begin and the end of an SQL statement because i like to measure the time the SELECT needed.
In datawindows i have the retrievestart and retrieveend events where i can exactly do what i wish to do.
In embedded SQL i use SQLCA which...
Hi all, have a happy new year!
I could not find another way to post an enhancement request for future PB versions, so I'll leave it here. If there is a better way to do so, please let me know.
We develop and maintain a quite large c/s application (...
Does the .Net DataStore product support generating a C# .Net DataStore API service from a SQL Server View DataWindow Object DataSource that will update the SQL Server View?...
We are migrating an existing PowerBuilder application to make use of SnapDevelop to handle the datawindow calls. Our system has a reporting area, where we give the user a selection of criteria they can use to customize the report. As the current sy...
Greetings community,
In the past few months, our company migrated multiple applications from Powerbuilder 9 to Powerbuilder 2019.
We did encounter something interesting: for varchar(max) and text column types, on our MSSQL database, all datawind...
This is in PB2019 Build 2082, using the Firebird SQL Database.
We have one user’s database from our application that is behaving extremely strangely for certain SQL retrieved through a datastore created at runtime (actually, our inherited datastore ...
Hi,
I am just after some advice - what SQL query builder would you all recommend , that works with SQL Anywhere 16 ?
regards
Andrew
...
Hi there,
Powerbuilder 12.5 classic application has no issues creating temporary tables in an Azure MSSQL database (account dbo user) but for some unknown reason... a deployed web application from PB 12.5 using the same connection parameters (user n...
Hello,
is there a way to influence the binding process between SnapObjects and a database (specifically Oracle) yet?
The issue we're facing is that when reading from an Column that has the type NUMBER, SnapObjects requires the property in the C# Mo...
I have been on this for days.
Please help with the snapobject v.2.0 usage below.
How do i make snapobject to run the multi-table sql query defined in DwSelectAttribute on the D_Rpt_Mm_Tbills poco class
public List<D_Rpt_Mm_Tbills> Test(param...
Hi
I do hope everyone is well.
I am trying to do an insert into sql statement within powerbuilder script. PB2019
I want to copy all the record from sales to sales_history - sales_history has all the fields of sales but in addition a archive_yea...
The code bellow works fine in SQLAnywhere and SQLServer 12 but fails on SQLServer Express 10.50.6000.
The result dw does not have the update property set and the key attribute in not set on the primary key fields.
ls_sql = "SELECT * FROM CMF "
ls_...
Hi,
We are using PB 6.5 version, which uses ntwdblib.dll for DB connection, We are suing SQL server 2008 R2. recently TLS1.0 on the SQL server is disabled. Which result in we are not able to access DB from PB. Everytime when application is try to op...
Dear Appeon Community,
I need information, restrictions, limitations that we should consider regarding an application developed in Powerbuilder 2017 can connect to databases in the cloud (SQL as a Service). This application will be hosted on Windows...
Hello,
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)?
...
Hello,
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.
INTEGER ll_certificate_id
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.
...
- Page :
- 1