Microsoft KB Archive/74234

{| = Token Too Big Message When Executing a SQL Statement =
 * width="100%"|

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 &quot;Token Too Big.&quot;

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

Steps to Reproduce Problem
 Start Q+E. From the File menu, choose Logon. Log on to a SQL Server where you have created a table with a text field more than 79 character in length. From the File menu, choose Open. Choose the SQL Query button.  Enter the following query: INSERT INTO VALUES ('This      is a very long string of text that will cause Q+E to      display an error message') Where is the name of a table in your database and is field defined as text with a length greater than 79.   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.
 * }