Board index » delphi » MS SQL Text datatype & ADO

Vlad Gonchar

Delphi Developer
Mon, 28 Apr 2003 03:00:00 GMT

MS SQL Text datatype & ADO

Have anybody tried to retrieve text field of 10K or so from SQL server usind
ADO ?
After reading each next record using TADOQuery.Next I get either 4K+ garbage
or 8K+garbage.
I have not been working with large objects before.
Do I have to take something special into account ?

Vlad Gonchar

 
Vlad Goncha

Delphi Developer
Tue, 29 Apr 2003 03:00:00 GMT

Re:MS SQL Text datatype & ADO


Quote
"Vlad Gonchar" <Vl...@Frogware.com> wrote in message

news:3a0b2b7d_1@dnews...

Quote
> Have anybody tried to retrieve text field of 10K or so from SQL server
usind
> ADO ?
> After reading each next record using TADOQuery.Next I get either 4K+
garbage
> or 8K+garbage.
> I have not been working with large objects before.
> Do I have to take something special into account ?

Sorry, guys

ADO is OK.
Reason was in Delphi evaluator - it takes only 4096 valid data + garbage to
actual size of field.

Vlad Gonchar

Other Threads

1. Delphi 1 / MS SQL / "Text" datatype

2. Stored procedures and MS SQL datatype text as parameter

3. ADO and retrieving MS SQL messages / PRINT statement text

4. MS SQL Server newbie - importing text to SQL tables from a text data feed

5. MS-SQL 6.5 & MS-SQL 2000

6. Removing&recreating indexes (MS-SQL, Delphi 5, ADO)

7. Mapping ADO DataTypes to Delphi DataTypes

8. ADO & Dates under ms sql

9. DELPHI ADO & MS SQL 2000 Requery question

10. ADO & MS SQL Server