This content has been marked as final. Show 12 replies
Thanks for the replay.
But I can't change anything in the database.
I checked in the database the variable datatype is varchar(1400) and the value in the field is not more than 700
even then am getting the error .
The version of the Progress is 9.1B
I have to manage the error from the java side. Is that possible?
Edited by: user10546563 on Sep 5, 2011 5:30 AM
I'm trying filter the very long string value from the database using the below query.
select cast(EngDetails as varchar(256)) as EngDetails from pub.GENCOND
controlling the field size using the below statement
but the same error is coming.
Is anything wrong with query.
the values which am able to retrieve are filtered using this query.
But for the long values again same problem is coming...
Please give me some suggetions
user10546563 wrote:Says who?
Sorry I can't change anything from the database.
I have handle the issue from java code.
Is that possible?I wouldn't stake my life on it, but I suspect not. The inherent problem is that Progress is NOT an SQL database.
If I recall correctly, character fields are natively implemented as null-terminated character strings and so can support just about any length; the specification ('x(40)' or whatever) is simply a default output format, but it appears that it's also used to set up the SQL schema for the table.
If there is a solution, I think you're much more likely to get it from a Progress user's group or the Peg. Alternatively, talk to your friendly neighbourhood DBA.
I need to connect to the progress database to retrieve the data from the tables.
But for some of the columns are giving the error
Exceded maximum length or precision...
but I'm not having the permision to change anything in the database...
using the data directory or using dbtool.
is it possible to get the data using any other languages or in any onthe way.
Please help me out of this error..