16.12.2013 8:08, Alex Peshkoff wrote: > And what do you think about a case when (I use old syntax for an example): > > alter user x [set] password 'y' [set] a [to] 'a', b [to] 'b'; > > Where should that set be placed? I prefer to: > > alter user x password 'y' set a = 'a', b = 'b';
IMHO, for syntax consistency "set" should be placed before all changing parameters. I.e. if password identifies user record to be changed, "set" after it is ok, but if password is a subject to change, "set" should be before it. -- WBR, SD. ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel