Update All With Too Many Characters Gives Missing Quote Error

When using the SQL command UPDATE with a character string that is longer than the field definition, SQL Server will truncate the string. Q+E should send the update, with the result being a truncated version of the update string. However, Q+E will generate the error message:

   Warning:  "SQL Syntax error: unclosed quote before character
              string <string>"

This message occurs because Q+E is acting as a pre-processor for the SQL Server. Q+E tries to warn the user of any errors in the query before it actually sends it to the command processor.

Because Q+E knows the definition of the table being updated, it is able verify whether the data contains errors as well as whether the Query is following the SQL Syntax for that driver.

In this case, Q+E has simply truncated the data along with some of the syntax of the query and essentially invalidated the query.

Steps to Reproduce Problem

1. Start Q+E.

2. Log on to SQL Server.

3. Open a file containing a character field.

4. From the Edit menu, choose Allow Editing.

5. Select an item in the character field.

6. From the Edit menu, choose Update All.

7. Modify the field by adding characters until more characters have been added than the field definition allows for.

8. Choose the OK button. The result will be the error message described above.

"Q+E for Microsoft Excel User's Guide," version 3.0, page 113