RE: SQL ... END SQL (was: Using directives within Informix 4GL)

> Jonathan Leffler wrote in message <3A7708D1.A3CFFB4@informix.com>... > >Richard Harnden wrote: > >> You could try wrapping the select in an SQL...END SQL block, > > > >Hooray; someone got it right! > > > > You are obviously a fan of SQL ... END SQL but I gotta admit > - my mind is > boggled at the move away from inline SQL towards this > old-fashioned-looking > concept in 4GL. Try writing an SQL parser that takes into account all the bells and whistles on 9.x and then you'll see why SQL..END SQL is so wonderful Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix #

Watson, Paul wrote in message <95bb6q$sss$1@news.xmission.com>... > >Try writing an SQL parser that takes into account all the bells and >whistles on 9.x and then you'll see why SQL..END SQL is so wonderful > But you've gotta mourn the passing of sweeter syntax for slightly uglier stuff. I have tried to write parsers in the past, principally to build a beautifier of 4GL code, and I've never finished one... too much hard work.