Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Unanswered: SELECT Query returns only 255 chars

    I am having trouble with an application, using VB6 and ADO to access an
    mdb file.

    The table has 3 text fields with 255 chars length each, when I do a query
    of the following form:

    SELECT F1 & F2 & F3 FROM Table

    The result is a recordset, but only the first 255 chars are returned.

    Anybody knows the reason of this behaviour or can give me an idea
    of what to do.

    I am concatenating the fields since the result is being used by a Spread7
    control.

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    It is because the String field can only take 255 characters. The 3 concatenated together make a string field. If you want them all use a memo field and then you will get the desired result.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •