Field definitions

Hi,

Our Progress 9.1 database shows field sizes when accessed through odbc.
(example: type=varchar, size=16) However the data contained in these fields
can be over this size, say 19 characters, and this causes problems when
accessing the data through ODBC. What is the best way to fix this,
server-side, to prevent data going in which is too big?

Thanks,

SW

"S W" wrote in message
news:1208792576.402318-at-grenada.network-i.net...
> Hi,
>
> Our Progress 9.1 database shows field sizes when accessed through odbc.
> (example: type=varchar, size=16) However the data contained in these
> fields
> can be over this size, say 19 characters, and this causes problems when
> accessing the data through ODBC. What is the best way to fix this,
> server-side, to prevent data going in which is too big?
>
> Thanks,
>
> SW
>
>


By the way, I now know there is a proenv utility that will fix this. It
takes a few minutes to go through every table in your database, and if it
finds any data that doesn't fit the sql definition, it changes the
definition! Very useful.

SW