I've got some realy heavy duty SQL stuff to do in Blitz, and as Blitz doesn't have a closing brace at the end of each line, [ ie: var myString:TString; ] i'm wondering if the editor has concatenation? I've never found it if so! The docs and a search of the forum havn't yielded answers so I thought i'd ask out here.
The only other way for me to keep these SQL statements legible is to buld them up over multiple lines, ie:
This would result in impaired performance in runtime aswell as being far from ideal. I'm already using, I dunno what to call it, like a preg_replace type thingy with Bruce's excellent MySQL module ( prepared Query's and setString method ) but as this project gets more convoluted i'm concerned the code will become unreadable in Blitz.
Thank you for any assistance.
The only other way for me to keep these SQL statements legible is to buld them up over multiple lines, ie:
q$="SELECT FROM" q$=q$+"servers as s, " q$=q$+"racers as r, " etc
This would result in impaired performance in runtime aswell as being far from ideal. I'm already using, I dunno what to call it, like a preg_replace type thingy with Bruce's excellent MySQL module ( prepared Query's and setString method ) but as this project gets more convoluted i'm concerned the code will become unreadable in Blitz.
Thank you for any assistance.