UPDATETEXT Function Not Recognised

Bryan H

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;

Harry Frankish

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

Harry Frankish

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