Discussions tagged SQL
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 2 months ago
- René Ullrich replied 2 months ago
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 (...
.Net DataStore support for Updating SQL Server Views
- How-to
- Last updated 3 months ago
- Logan Liu @Appeon replied 3 months ago
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?...
How to use SetSqlSelect on a report using SnapDevelop
- How-to
- Last updated 8 months ago
- Olan Knight replied 8 months ago
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...
Increase column sizes on hundreds of datawindows
- Advice
- Last updated 1 year ago
- mike S replied 1 year ago
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...
Error -15448 return from Retrieve() called on created DataStore
- Resolved
- Issue
- Last updated 1 year ago
- Daniel Vivier replied 1 year ago
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 ...
SQL query builder software - SQL Anywhere 16
- Advice
- Last updated 1 year ago
- Adolfo Chairez Gallegos replied 1 year ago
Hi,
I am just after some advice - what SQL query builder would you all recommend , that works with SQL Anywhere 16 ?
regards
Andrew
...
MSSQL temporary tables (#) creation (AZURE) from Powerbuilder Web
- Misc
- Last updated 2 years ago
- Pierre Rene replied 2 years ago
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...
SnapObjects Oracle Model Binding
- Issue
- Last updated 2 years ago
- Logan Liu @Appeon replied 2 years ago
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...
How to Make SnapObject 2.0 Use run the query from DwSelectAttribute
- Resolved
- How-to
- Last updated 2 years ago
- Gbenga Owolabi replied 2 years ago
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...
Database update not set in dynamic DW with SQLServer Express
- Resolved
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
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_...
Powerbuilder 6.5 not able to connect SQL 2008 R2 after disabling TLS1.0
- Issue
- Last updated 3 years ago
- Michael Kramer replied 3 years ago
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...
GetItemNumber returns negative value which is not in the actual resultset
- Resolved
- How-to
- Last updated 4 years ago
- Bhanu Prakash replied 4 years ago
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...
Commit transaction error
- Resolved
- Issue
- Last updated 4 years ago
- Appeon Support Team replied 4 years ago
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.
...
How Can we Get support for fields that New Extended Character Support
- Issue
- Last updated 5 years ago
- Chris Pollach @Appeon replied 5 years ago
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...
PowerServer MSSQLSERVER Options
- Issue
- Last updated 5 years ago
- Chris Pollach @Appeon replied 5 years ago
Dear all,
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:
Trusted...
- Page :
- 1