Problem with a field of type varchar(4000) and TZQuery
Posted: 01.03.2007, 11:16
I have a problem that I don't know how to resolve:
I'm using a TZQuery inside a class. I have created this TZQuery dinamically to access a table (in a MSSQL Server) that has a field of type varchar(4000). The result of the query for this field is a string of 256 characters long. So my trouble is that there are values for this field longer than 256 characters, and I can`t modify the database.
How could I resolve this problem?
I'm working with Delphi 7 and MSSQL Server 2000.
Sorry for my english, It isn't my native language.
I'm using a TZQuery inside a class. I have created this TZQuery dinamically to access a table (in a MSSQL Server) that has a field of type varchar(4000). The result of the query for this field is a string of 256 characters long. So my trouble is that there are values for this field longer than 256 characters, and I can`t modify the database.
How could I resolve this problem?
I'm working with Delphi 7 and MSSQL Server 2000.
Sorry for my english, It isn't my native language.