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

Where did my @Variables go?

JPMJPM Posts: 8 Bronze 2
edited February 14, 2007 6:40AM in SQL Prompt Previous Versions
Hi,

I'm busy with a rather sizable sql script. To my dismay SQL Prompt does not list any of my declared @variables anymore. Why is this? Can it be fixed?

Thank you,

JP

Comments

  • Options
    JPMJPM Posts: 8 Bronze 2
    Hi,

    Nevermind, I got it working.

    My script contained some errors. I simply parsed the script in the Management Studio, fixed the errors, and code completion worked perfectly again.
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi JP,


    Glad you got it sorted out. Syntax errors can completely screw everything up because the parser isn't always able to recover from them in a useful fashion. You can however highlight errors using SQL Refactor, although you need to do something like layout the script to get it to do this since it won't do it automatically.


    HTH,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.