> Dear Sir/Madam,
> I am using MySQL and MyODBC 2.50.24 with PB6.0. My problem is that I
> retrieve no row if the datawindow retrieve argument is larger than 9.
> create table company (
> id int unsigned not null auto_increment,
> name varchar(50) not null,
> primary key (id),
> unique name_idx (name)
> Retrieve argument of datawindow is "id" datatype is "number"
> The sql for datawindow is
> select id, name from company where id = :id ;
> The correct row can be retrieved for id is from 1 to 9, but no row will
> return when id is over 9
> But there is no problem inside DBA painter.
> Is there anything I have to config MyODBC?
Did you set the MyODBC flag:
Don't optimize column width