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

Reply via email to