 |  |  |  |  |  |  |  |
powerbuilder+mysql
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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:
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:
•
•
•
•
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).
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
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
|
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
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
