•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,786 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,379 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 6261 | Replies: 3
 |
•
•
Join Date: May 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
hi,everyone
my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I don't know why?who can help me? thank you. :cry:
my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I don't know why?who can help me? thank you. :cry:
•
•
Join Date: Aug 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hello Uma,
I have the same problem. I am working with Powerbuilder 8 and 10 with MySQL 5.0.4 with MyODBC 3.51.12 (the latest, still in test) By the way, this version of MyODBC solves a problem in Powerbuilder 10 with the datatype TIME, in Powerbuilder 8 you don't have that problem.
The only workaround that I found out for the retrieve problem is to change the retrieval argument from number to string, the retrieves are now going fine. I am not happy with the solution, but it works.
By the way I don't know how to find a way to let Powerbuilder know when in the database a column has datatype Decimal that it is a decimal and not a char() and the datatype Text is for Powerbuilder a char(-1). :cry:
Do you have the same problem?
Greetings Steven
I have the same problem. I am working with Powerbuilder 8 and 10 with MySQL 5.0.4 with MyODBC 3.51.12 (the latest, still in test) By the way, this version of MyODBC solves a problem in Powerbuilder 10 with the datatype TIME, in Powerbuilder 8 you don't have that problem.
The only workaround that I found out for the retrieve problem is to change the retrieval argument from number to string, the retrieves are now going fine. I am not happy with the solution, but it works.
By the way I don't know how to find a way to let Powerbuilder know when in the database a column has datatype Decimal that it is a decimal and not a char() and the datatype Text is for Powerbuilder a char(-1). :cry:
Do you have the same problem?
Greetings Steven
•
•
•
•
Originally Posted by uma
hi,everyone
my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I don't know why?who can help me? thank you. :cry:
•
•
Join Date: Nov 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
By the way I don't know how to find a way to let Powerbuilder know when in the database a column has datatype Decimal that it is a decimal and not a char() and the datatype Text is for Powerbuilder a char(-1).
Try this:
ls_type = dw_1.describe(ls_col1 + '.Coltype')
ls_type can be:
'number'
'char'
'decimal'
...
Try to see help for more. HOpe this helps.
By the way i also has a problem connecting to mysql for my first time.
I am using PB 6.5 with Sybase as my BackEnd, I am trying to use and connect to MySQL Server but got an error "[MySQL AB][MyODBC]ERROR : Client does not support authentication protocol requested by server;
consider upgrading MySQL client " during ODBC connection, does someone encounter the same error message? What do you mean by that error. Please enlighten my mind.
I am very much open for any suggestion or ideas, please help!
Thanks,
Raul
•
•
Join Date: Jul 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi.
I have the same problem, with an argument. Only change the column datatype to decimal. I'm using pb10
Bye.
I have the same problem, with an argument. Only change the column datatype to decimal. I'm using pb10
Bye.
•
•
•
•
Originally Posted by raulaisleen
Try this:
ls_type = dw_1.describe(ls_col1 + '.Coltype')
ls_type can be:
'number'
'char'
'decimal'
...
Try to see help for more. HOpe this helps.
By the way i also has a problem connecting to mysql for my first time.
I am using PB 6.5 with Sybase as my BackEnd, I am trying to use and connect to MySQL Server but got an error "[MySQL AB][MyODBC]ERROR : Client does not support authentication protocol requested by server;
consider upgrading MySQL client " during ODBC connection, does someone encounter the same error message? What do you mean by that error. Please enlighten my mind.
I am very much open for any suggestion or ideas, please help!
Thanks,
Raul
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- Powerbuilder + MySQL (MySQL)
- SQL Server vs MYSQL vs MSQL (i'm stopping now) (MS SQL)
Other Threads in the MySQL Forum
- Previous Thread: MySQL insert statement
- Next Thread: Grouping question
