SQL.Exec - possible to retrieve more than 255 characters?

Michael_Strattner

I'm using a Livelink 9.1.0.3 server running on Windows with a Oracle DB on Solaris.In my module I connect to a MSSQL 2000 Server and read information stored in several tables.But the maximum number of chars I get is 255 (out of columns with type varchar(900) or varchar(4000)).What do I have to do to get the complete text?Help would be appreciated...many thanksMichael Strattner

KJM_Associates_(kjmadmin_-_(deleted))

I don't know if this helps, but we use Microsoft SQL and have custom tables with fields over 255 characters. The fields that have more than 255 are defined as text fields rather than varchars. I am able to store and pull more than 255 characters that way.