Project: Retrieving text fields from SQL Server 6.5 
Author Message
 Project: Retrieving text fields from SQL Server 6.5

Hi. I've used the appendchunck method to insert text into a SQL text field,
using a stored procedure...

Dim cl2 As rdoColumn
            Dim rs2 As rdoResultset
            Dim qd2 As New rdoQuery
            Dim cnx2 As New rdoConnection
            cnx2.Connect = "uid=sa;pwd=;server=SPIDER;driver={SQL
Server};database=EcoAfrica_B;dsn="
            cnx2.CursorDriver = rdUseOdbc
            cnx2.EstablishConnection
            Set qd2.ActiveConnection = cnx2
            qd2.sql = "{ Call
EcoAfrica_B..Add_Establishments(?,?,?,?,?,?,?,?,?,?) }"
            qd2(0) = txtEstablishmentName
            qd2(1) = sbriefdescription
            qd2(2) = var1
            qd2(3) = ValidData
            qd2(4) = cboTourOperators.ItemData(cboTourOperators.ListIndex)
            qd2(5) = cboEstType
            qd2(6) = Durations
            qd2(7) = var2
            qd2(8) = Web
            qd2(9).AppendChunk (sfulldescription)

            Set rs2 = qd2.OpenResultset(rdOpenForwardOnly)

This works fine, it adds the text to the data base. However, when I try and
retrieve that data from the database using this method...

    Dim rs2 As rdoResultset
    Dim qd2 As New rdoQuery
    Set qd2.ActiveConnection = cnEstType
    qd2.sql = "{ Call EcoAfrica_B..Sel_Establishments(?) }"
    qd2(0) = gPRODID

    Set rs2 = qd2.OpenResultset(rdOpenForwardOnly)

    If rs2(9).Size > 0 Then
    sfulldescription = RTrim(rs2(9))

    End If

I get an error (Client Cursor: 11 - No update tables are specified)

I know for a fact that the data is there because I cheched it in SQL
Enterprise Manager.

Please Help!!! How do I load in data from a SQL text field, size 16



Mon, 12 Nov 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Loading Rich Text Box from SQL Server 6.5 Text Field

2. Import text file in SQL Server 6.5 via SQL in Visual Basic

3. Import text file in SQL Server 6.5 via SQL in Visual Basic

4. Storing and Retrieving Images in SQL Server 6.5

5. Delete a field in SQL Server 6.5

6. image fields in SQL Server 6.5, how to..?

7. Delete a field in SQL Server 6.5

8. Text/Memo Fields in SQL 6.5

9. ADO / SQL 6.5 / Text Fields

10. Searching a Text column (SQL Server 6.5)

11. Problem with Crystal Reports and Excel OLE-object stored in SQL Server 6.5 and vertical text

12. Problem retrieving large text fields from SQL Server

 

 
Powered by phpBB® Forum Software