Text Type Column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LUIS - 02 Dec 2004 00:29 GMT

I am using ADO with VB6 and SQL2000 to retreive data from tables with text
type columns. Sometimes works, sometimes not. Syntax as follow

Dim RS As ADODB.Recordset
Set RS = CursorGet("sp_RetrieveData", Var1, Var2)
txtTextBox.Text = RS("TextTypeColumn").Value

Is necessary some .LIB, Drivers or something? Please, help me.
Beforehand, thank you very much.

Signature

Luis Garcia
MS Developer

Reply to this Message

Jason Tost - 29 Dec 2004 17:39 GMT

Take a look at the Recordset GetChunk method. Large data formats (i.e.
image, text, ntext) will allow updating small amounts of data through
select/update/insert, but with relatively larger amounts of data (I
believe >8K, or one data page) you must use GetChunk/AppendChunk to read
and write respectively.

See "text and image data types" in the Microsoft SQL Server Books
Online, as well as the MDAC SDK for more info:

http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthgetchunk.asp?frame=true
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthappchunk.asp?frame=true

Reply to this Message

VB Forum / Database Access / December 2004

Text Type Column