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).

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