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

Resolved [SOLVED] Problem with MySQL Native Driver ,Uppercase and double quotation in columns (SQL statements)

  1. Issue
0
Votes
Undo
  1. Willian Padilha
    Willian Padilha
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 23 October 2017 15:04 PM UTC

I have set the datasource​

and my PowerScript is this

CONNECT USING SQLCA;

Retrieve is working fine, but Update, Insert and Delete not

 

my Datawindow Sql Code

 

anyone have any idea what may be wrong?

Very grateful for any response

 

Sorry for my bad English.
Greetings from Paraguay

  1. ASE
  2. DOUBLE
  3. MySQL
SSL self certificate install on linux
Problem when deploy packaged powerbuilder 2017 app...
Accepted Answer
Willian Padilha
Willian Padilha Accepted Answer Pending Moderation
  1. Monday, 23 October 2017 20:04 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

[SOLVED]

The problem is in MySQL config

my.ini/cnf

sql_mode =ANSI_QUOTES

SET GLOBAL SQL_MODE=ANSI_QUOTES;

 

Thanks Marcos for your time and help

 

 

Comment
There are no comments made yet.
Responses (2)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Monday, 23 October 2017 15:35 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi,

Google for "OPTION=135168" to include in the transaction object's DBParm property, for example:

SQLCA.DBParm = "ConnectString='DSN=mydb;UID=;PWD=;OPTION=135168'

That should fix your problem.

Cheers,

Marco

Comment
Willian Padilha
  1. Willian Padilha
  2. Monday, 23 October 2017 16:25 PM UTC
Hello Marco, but I am not using DBPARM, because APPEON already caches it automatically



 



See HELP (I'm use Static Option)



https://www.appeon.com/support/documents/appeon_online_help/1.5/server_configuration_guide_for_net/ch04s04s02.html#Transaction_Objects

  1. Helpful
Marco Meoni
  1. Marco Meoni
  2. Monday, 23 October 2017 18:56 PM UTC
Yes sure, I just pointed you to the syntax. In Appeon you may wanna try to specify any extended DBParm attribute in the data source -> Extended Options.



See Appeon help: "Specify the connection parameters that are not listed above. The value should be in this format: "parameter_name=###" where "parameter_name" is the name of the connection parameter, for example, TextSize=64000, this sets the maximum size of text or binary data sent or received from ASE to 64 KB. If there are more than one parameter, separate them by semicolon (";")."



Cheers,



Marco



P.S.



I assume you're using MySQL native driver, not ODBC.

  1. Helpful
Willian Padilha
  1. Willian Padilha
  2. Monday, 23 October 2017 19:11 PM UTC
I already tried to use the extended options, but there was no change Marco.



would you know to indicate which parameter name might indicate in the extended options?



Mysql Native Driver (as you can see in the first image)

  1. Helpful
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.