Mark wrote:
>
> Dear Sir/Madam,
>
> >Description:
> 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.
>
> >How-To-Repeat:
> 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?
Hi Mark
Did you set the MyODBC flag:
Don't optimize column width
Tschau
Christian
