Intellisense showing blank values for tables

jgonnering

I am using SQL Prompt 7.4.0.471 in SSMS 12.0.4100.1 and in the intellisense drop down, the table suggestions are blank. If I put my cursor over it, the table definition popup will appear next to it just fine.

I have a screen shot, but I'm not sure how to attach it.

If I have a statement like below, and I bring up SQL Prompt intellisense after the ON clause, all the column join suggestions (paper clip icon) are fine, but the table alias only (r, cr) are blank.

SELECT *
FROM dbo.Report as r
JOIN ClientReport as cr
ON

Harry Frankish

Hi jgonnering

Please could you email the screenshot to SqlPromptTeam@red-gate.com?

Did this issue only start happening when you upgraded to 7.4.0.471?

Cheers
Harry

jgonnering

Ok, I will email. The issue started with 7.4.0.245 (I was sent a link for this to solve another forum issue I submitted).

Michael Clark

Thank you for your email, we have logged a bug SP-6079 and will let you know if we find a fix.

Best,
Michael

Michael Clark

Our latest SQL Prompt 7.4 beta fixes this issue:
https://forums.red-gate.com/viewtopic.php?f=169&t=80560

jgonnering

I can confirm that the latest beta fixes the issue. Thank you! Case closed.

pattyblack

If it is showing blank values for tables, it can disrupt productivity and accuracy, especially during coding or writing assignments. However, tools like many-essays could support writing tasks by providing structured guidance or inspiration for completing assignments. While IntelliSense assists coding, resources like many-essays can be invaluable for writing more effectively and efficiently.