Keyword list - where is it?

mg

The original product (PromptSQL) had a utility for adding keywords. Is there or will there be one in this product?

Bart Read

Hi there mg,


The current version bases the list of keywords it uses on the version of SQL Server you connect to, so SQL Server 2005 has a much more extensive list than SQL Server 7 or 2000. I'm assuming your enquiry relates to wanting to tweak the auto-capitalisation/auto-lowercasing functionality? We may make this more configurable in the future but for now you can't edit the keyword/data type/function lists.

If you want to configure the list of words after which the popup will appear you can do this by editing the EngineOptions.xml directly. You'll find this in C:\Documents and settings\{username}\Local Settings\Application Data\Red Gate\SQL Prompt 3. The list of words is at the end of the file in the <PopupTriggerWords> section.

Hope that helps.


Thanks,
Bart

mg

Thank you for your "prompt" reply

yes - auto/upper functionality is what I would like to tweak. It would be nice to match the color coding with the uppercase. Definitely not a show stopper, though.