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

Feature Request -- Parameter Prompting

MikeONeillMikeONeill Posts: 131
edited November 6, 2008 2:08AM in SQL Prompt Previous Versions
When you use a function , the tooltip shows you the parameters that the function expects

As you start to enter the various parameters , the prompting stops and the tool tip disappears . I assume the SQL is in an inconsistent state and stops prompting.

I got around it by having a second line with the function on is so I could see the tooltip on that one

It would be really nice if the prompting continued a la VS Intellisence , as each parameter is added and then a comma a prompt for the next parameter shows .

I really am lazy !!

Cheers

Mike

Comments

  • Options
    Thanks for your feedback. SQL Prompt should work as you wish. When using a user defined function SQL Prompt should prompt you with the parameters needed for that function. This should happen in the way that you describe, as you type the parameters and then a comma SQL Prompt should move to the next parameter in the tooltip. If you do a simple test with an Adventureworks function you should see this e.g.

    SELECT dbo.ufnGetProductDealerPrice()

    When you place the cursor in the (), SQL Prompt should highlight the first parameter needed and then move onto the next one after you type a comma. Does this work for you?

    If this works but you're still having issues with a certain function could you give me an example?
  • Options
    Do you still need assistance with this posting or have you been able to get the parameter prompting working?
  • Options
    No Problem now Thanks
Sign In or Register to comment.