"S W" <antispamsteve@[EMAIL PROTECTED]
> wrote in message
news:1208792576.402318@[EMAIL PROTECTED]
> 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
|
