What are the challenges you face when working across database platforms? Take the survey
Options

UPDATETEXT Function Not Recognised

SQL Prompt is not recognizing the SQL Server's UPDATETEXT function. The formatting results drop the table name out of the correct syntax and then return a Error Inserting Semicolons message. Example code:

Original:
UPDATETEXT TableName.FieldName @PARAMptrval NULL NULL @pValues;

Outcome:
UPDATETEXT FieldName @PARAMptrval NULL NULL @pValues;

Comments

  • Options
    Harry FrankishHarry Frankish Posts: 53 New member
    Hi Bryan

    Thanks for reporting this. I've reproduced the issue here and will try to get a fix to you as soon as possible.

    Until then there are 2 possible ways to prevent SQL Prompt removing the table name:
    1 - In "SQL Prompt > Options... > Inserted code > Qualification" select the "Qualify column names with table name" checkbox.
    Or
    2 - In "SQL Prompt > Options... > Format > Actions" deselect the "Qualify object names" checkbox

    Thanks again!

    Harry
  • Options
    Harry FrankishHarry Frankish Posts: 53 New member
    Hi Bryan

    I think this is now fixed in this build: http://download.red-gate.com/EAP/SQLPrompt/SQLPrompt_7.5.0.942.exe

    As it's essential syntax, columns in an UPDATETEXT statement should now always be qualified with the table name regardless of your settings.

    Please let us know if you have any further problems.

    Cheers
    Harry
Sign In or Register to comment.