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.
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.
Comments
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
Principal Consultant
bartread.com Ltd
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.