Hi All,
I've now got my OpenROAD code to set all keywords to Pascal case - except for SQL keywords which are in uppercase. One thing I can't resolve is that I have certain keywords that exist both inside and outside of an SQL statement. Here's an example... On Click RetrieveBtn = Begin ... SELECT LocalVar = table_value FROM main_table WHERE table_value BETWEEN 1 AND 100 BEGIN Field(RetrieveList).ValueList.ChoiceItems[Row].EnumValue = LocalVar; Row = Row + 1; END; ... End Ideally I want 'begin' and 'end' to be in uppercase when part of an SQL statement but Pascal case when not. Can I define a region as, e.g. starting with 'SELECT' and ending with 'END;', and use this region within the substitute command to set the appropriate keywords to uppercase? Hope this makes sense... Thanks Dave Dave Clark Analyst Programmer Aviagen Ltd Newbridge Edinburgh EH28 8SZ ': +44 (0) 131 527 8165 *: dcl...@aviagen.com <mailto:dcl...@aviagen.com> ***************************************************************************** This e-mail contains confidential information and is intended solely for use by the individual named or entity to whom it is addressed. Please notify the sender and postmas...@aviagen.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the named addressee, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Aviagen accepts no liability for the content of this e-mail and any consequences of actions taken in reliance on the contents, unless that information is subsequently confirmed in writing. Any views, opinions or actions presented in this e-mail are solely the author's and have not been approved by Aviagen. Any defamatory statements or infringing communication is contrary to Aviagen policy and outside the scope of the employment of the individual concerned. No employee or agent is authorized to conclude any binding agreement on behalf of Aviagen with another party by e-mail. Aviagen has taken reasonable precautions to ensure no viruses are present in this e-mail, but cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments. ***************************************************************************** -- You received this message from the "vim_use" maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php