Questions? Feedback?powered byOlark live chat software
Bug 3278

Arguments are empty in the sqlsyntax of the transaction dberror event 11 September, 2019

Ferdinand Fischer
02 September, 2019
Product: PowerBuilder Category: PowerScript
Version: 2017 R2 Publishing: Public
Status: Scheduling Priority: P3
Classification: Sybase (legacy) bug Resolution:
Ken Guo 11 September, 2019
Hi Ferdinand,

Thanks for reporting this problem! We reproduced it on our end and will do further research to figure it out. We will keep you posted about the progress.

BTW, PB 12.6 has the same issue.

Regards,
Ken
Ferdinand Fischer 03 September, 2019
Test.7z (328KB)

Hi Ken,

i made a simple Testcase.
You need a ODBC Connection named Test for the Database.
User:dba
Pwd: sql

SQL in SQLPreview:
SELECT bez from test where menge =1

SQL in DBError:
SELECT bez from test where menge =0

Regards,
Ferdinand
Ken Guo 03 September, 2019
Hi Ferdinand,

Can you provide a reproducible simple test case (with PBT/PBL)? This would help us to analyze the issue. Thanks for your understanding!

Regards,
Ken
Ferdinand Fischer 02 September, 2019
*Phenomenon:
If an embeded sql causes an error the arguments in sqlsyntax are empty of the dberror event.
They are filled In the sqlpreview event.

*Reproduce Steps:
Execute an embedded sql with arguments,that causes an error and compare both events.

Remarks:
The SQlsyntax should be the same in the dberror and sqlpreview events.
OS:
Windows 10 
Platform:
32-bit 
Database Type:
SAP SQL Anywhere 
Database Version:
17