Forums » General Discussion

Thread: <Unknown identifier @variable>

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1
olovka8

Posts: 1
Registered: 11/9/11
<Unknown identifier @variable>
Posted: Nov 9, 2011 2:13 AM
 
  Click to reply to this thread Reply

When I debug a sql script, and I am going step by step thru script, I can't see varibales even if they are correctly set. For example:

SELECT 'asdsdasd' INTO @myvariable;
SELECT id INTO @myid FROM mytable WHERE some_column = @myvariable;

Both @myvariable and @myid when I add them to the watch list I see <Unknown identifier @myvariable> and <Unknown identifier @myid> as their values. Also when I hover with mouse over them I see the same value - <Unknown identifier ...>

Is there a way to debug a script step by step and see the values of variables while debugging?



Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums