Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

rdoAccess

Could any one tell me why the following code gives me this error:
"No columns were bound prior to calling SQLFetchScroll/SQLExtendedFetch"
Here is the code:
strSQL = "Select long_desc from logs where log_id = 123362"
Set .rs = .cn.OpenResultset(strSQL)
'this gives me the above error. Long_desc is a Text datatype on a remote data source
'I am trying to access the data using GetChunk, if i use "select * from logs where log_id = 123362" i do not get this error but
'long description seems to be null. i.e. GetChunk always returns no bytes.
'I am using this code to access the data.
Dim desc as string
On Error Resume Next
    Chunk = rs!long_desc.GetChunk(10)
    If Chunk > "" Then
        ¬†¬†Desc = Desc & Chunk
          While Chunk > ""
            Chunk = rs!long_desc.GetChunk(10)
            Desc = Desc & Chunk
          Wend
    Else
        MsgBox ("field is null")
   End If
Please could anyone help?
0
Coates
Asked:
Coates
  • 3
1 Solution
 
CoatesAuthor Commented:
Another error occurs when i user "Select * from logs where log_id = 123362"
When i go to use GetChunk i get the following message:
"Invalid dattime format, error in parameter 23"
??????????????????????????????????
0
 
CoatesAuthor Commented:
Ive just tried merely assigning the value in the text fieldto a variable using this code.
Desc = rs!long_desc
And i got the same error: "Invalid datetime format, error in parameter 23"
What does this error mean?
0
 
cymbolicCommented:
There have been some noted bugs in handling long text fields.  Generally thye workaround is to include one ordinary field/column, such as a long, etc. in your resultset.  One bug workaround is to include an additional column, and update it with its same value when updateing a text field, otherwise your text field does not get updated.  Try including another regular column in your resultset.  Memo fields are only accessed when called for later in your code, while processing your resultset.  They don't come down with the other columns in your resultset, only if/when accessed while processing the resultset.
0
 
CoatesAuthor Commented:
Thanks, that worked fine.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now