Token Too Big Message When Executing a SQL Statement

 Last reviewed: November 2, 1994
Article ID: Q74234

SUMMARY

Q+E uses tokens of 80 bytes to send data to a SQL server. Issuing a SQL statement that attempts to insert or update a record more than 79 characters long will cause Q+E to display the error message "Token Too Big."

Inserting or updating records up to 254 characters from the Data Form works correctly.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Q+E.

  2. From the File menu, choose Logon.

  3. Log on to a SQL Server where you have created a table with a text field more than 79 character in length.

  4. From the File menu, choose Open.

  5. Choose the SQL Query button.

  6. Enter the following query: 

          INSERT INTO <tablename> (<fieldname>) VALUES ('This
      is a very long string of text that will cause Q+E to
      display an error message')

    Where <tablename> is the name of a table in your database and <fieldname> is field defined as text with a length greater than 79.

  7. The following error message will be displayed: 

          Token Too Big: ('This is a very long string of text that will
      cause Q+E to display an error message')

Microsoft is researching this problem and will post new information here as it becomes available.

KBCategory: kbother
KBSubcategory:

Additional reference words: noupd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.