 |
|
| Computers Forum Index » Computer - Databases - Progress » Field definitions |
|
Page 1 of 1 |
|
| Author |
Message |
| S W |
 Posted: Mon Apr 21, 2008 8:40 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| SW... |
| Posted: Sun Jun 01, 2008 7:47 pm |
|
|
|
Guest
|
"S W" <antispamsteve at (no spam) =No-Spam=.org> wrote in message
news:1208792576.402318 at (no spam) grenada.network-i.net...
Quote: 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 |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Fri Nov 27, 2009 10:40 am
|
|