255) or TEXT field in Delphi program

Jan Doggen

Delphi Developer

Mon, 01 Aug 2005 20:23:42 GMT

Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

Help,

I cannot retrieve the data from a MS-SQLServer VARCHAR(n>255) or TEXT field
in my Delphi program. I've tried all combinations of
MmoChangeLog.Text :=
MmoChangeLog.Assign()
MmoChangeLog.Lines.Add()
MmoChangeLog.Lines.AddStrings()
left of the assignment, and
Fields[0].AsVariant;
Fields[0].AsString;
Fields[0].VAlue;
Fields[0].Text;
right of the assignment,
but nothing seems to work.
The data are retrieved with a query:
SELECT MUT_DESCRIP FROM MUTSTRU WHERE MUT_ID=15

It almost looks like a FAQ, but so far I haven't found anything.
Who can help me out?

TIA
Jan Doggen

Sundial Service

Delphi Developer

Wed, 03 Aug 2005 01:14:36 GMT

Re:Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

Quote

Jan Doggen wrote:
> Help,

> I cannot retrieve the data from a MS-SQLServer VARCHAR(n>255) or TEXT
> field in my Delphi program. I've tried all combinations of
> MmoChangeLog.Text :=
> MmoChangeLog.Assign()
> MmoChangeLog.Lines.Add()
> MmoChangeLog.Lines.AddStrings()
> left of the assignment, and
> Fields[0].AsVariant;
> Fields[0].AsString;
> Fields[0].VAlue;
> Fields[0].Text;
> right of the assignment,
> but nothing seems to work.
> The data are retrieved with a query:
> SELECT MUT_DESCRIP FROM MUTSTRU WHERE MUT_ID=15

You may have to use a TBlobStream object to handle LONGVARCHAR data. This
actually goes back to the definition of ODBC itself.

----------------------------------
Fast automatic Paradox/Delphi table repair at a click of a mouse!
http://www.sundialservices.com/products/chimneysweep

Other Threads

1. Cannot retrieve the data from a MS-SQLServer VARCHAR(n>255) or TEXT field

2. sqlserver varchar field truncated to 255

3. VarChar fields > 255 chars

4. SQL Server 7 Varchar fields > 255

5. MS SQL7.0 Text Data types > 255

6. Problem reading memo or VarChar>255 with SQL Server

7. varchar>255 and collate DE_DE

8. VarChar(>255) in SQL Srvr 7 problem

9. VarChar(>255) in SQL Srvr 7 REVISED

10. VARCHAR > 255 avec