Urgent please help Ignore Space after function name
Posted by: Prashant Nirgun
Date: August 15, 2013 08:47AM

Hi

I am Prashant I am using PowerBuilder 11.5 and MySQL 5.1 on Windows 7 32 Bit. PowerBuilder Application required Optional prameter IGNORE_SPACE Ignore space after function names 4096 Tell server to ignore space after function name and before “(” (needed by PowerBuilder). This makes all function names keywords.

Previously i was using ODBC Driver there we do have Option in the form of checkbox to set this option.

Now i am trying to connect using JDBC driver i sucesfully connect to MySQL but the problem is whenever is used any function like sum() or count() it give PowerBuilder error
Database C0038: SQLSTATE = 42000 You have an error in SQL syntax; check the manual for corrosponding to your MySQL server version for the right syntax to use near '*) from my_table' at line 1

you will get more info on
http://dev.mysql.com/doc/refman/5.0/es/myodbc-configuration-connection-parameters.html
http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-configuration-connection-parameters.html#codbc-dsn-option-flags

since i am new to this please help i am in great trouble.

my connection parametrs are as follows
// Profile Transporter3
SQLCA.DBMS = "JDBC"
SQLCA.LogPass = "tss"
SQLCA.LogId = "root"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='com.mysql.jdbc.Driver',URL='jdbc:mysql://localhost:3306/mydb'"

Options: ReplyQuote


Subject
Written By
Posted
Urgent please help Ignore Space after function name
August 15, 2013 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.