Supposed to recognize views and user-defined funcs?
BrianFinkel
Posts: 33
Hi, I'm trying out SQL Prompt 3, and it seems improved over SP2 (especially the UI), but I have some questions:
1 - Is it supposed to know about views? I get no suggestions for views or columns in views.
2 - Is it supposed to know about User-Defined Funcs that return a table? Does not work for me.
3 - Supposed to know about sproc/udf input params when calling? Also does not work.
If these items are not yet supported, I would suggest that they are pretty important areas of functionality, at least for me. Any estimate on when they will be implemented?
Thanks,
Brian
1 - Is it supposed to know about views? I get no suggestions for views or columns in views.
2 - Is it supposed to know about User-Defined Funcs that return a table? Does not work for me.
3 - Supposed to know about sproc/udf input params when calling? Also does not work.
If these items are not yet supported, I would suggest that they are pretty important areas of functionality, at least for me. Any estimate on when they will be implemented?
Thanks,
Brian
Using Sql Prompt 3.7 with SQL Server 2000, Query Analyzer, and 2005 Mgmt Studio.
Comments
I think Prompt should do all of these things. I'm curious to know wht it wouldn't work for you. Perhaps you're in the wrong database context? Putting USE <dbname> in the query window might help.