Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Powerserver and SyntaxFromSql

  1. Issue
0
Votes
Undo
  1. Sylvain .
    Sylvain .
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 22 June 2020 19:59 PM UTC


MySQL Server 5.6.26
MySQL ODBC 5.3.10 ANSI
Internet Explorer: 11.471.17134.0
PowerBuilder Universal: 2019R2 Build 2328.00
PowerServer (PB Edition): 2020 Build 2323.00 From AEM


The following syntax:

ls_Syntax = SQLCA.SyntaxFromSql("SELECT CONVERT(' ', CHAR(15)) AS UCC_001, CONVERT(' ', CHAR(150)) AS UCC_002, curdate() AS UCC_003, CONVERT(' ', CHAR(20)) AS UCC_004, CONVERT(0, DECIMAL(12, 2)) AS UCC_005", "style(type=grid Report=yes Vertical_Size=60)", ls_ERR)

 

Is causing the following message

 

When I click the OK button ls_Syntax AND ls_ERR are empty.

 

The exact same object and line is working fine in an EXE.

 

Anyone knows what I'm doing wrong?

 

TIA

Sylvain

 

PowerServer IIS Defult Doc vs Directory Browsing
Return Code for appeonfileservice.of_appeonDOWNLOA...
Responses (1)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 22 June 2020 20:34 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

PowerServer already supports MySQL: https://docs.appeon.com/ps2020/server_configuration_guide_for_net/supported_database_drivers.html

But you need to use the native .NET provider (not ODBC) as mentioned in the documentation.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.