List:MySQL ODBC« Previous MessageNext Message »
From:Christian Mack Date:August 13 1999 3:28pm
Subject:Re: Powerbuilder datawindow
View as plain text  
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

Thread
Powerbuilder datawindowMark13 Aug
  • Re: Powerbuilder datawindowChristian Mack13 Aug