I have been going thru the manual and most likely not looking in the correct location, or maybe its not even possible being as I have not seen it listed in anyones code. I think the correct terminology is called indentation.
Under the way in which I know here is what the code would look like under a button:
fpmi.db.runQuery("select machine,serial,mech1,mech2, runtime, mechpg,shift from prodtrack where shift =1
Now as some of the more experienced people know some of these queries can get lengthy and sometimes you need to scroll your edit window left and right in order to see the whole query or code that has been written. What I am asking is if under the current version if there is a way to make the runQuery look like this:
fpmi.db.runQuery("select machine, serial
where shift =1
I guess the best way to describe it is similar to the query you see when you use MS-SQL Studio Manager GUI. When I ever I try to split up the query on multiple lines I get the Lexical error message.
Currently I have one very large query that I have split up as follows but it does not look pretty and there is more than likely a much better way.
q1 = "machine, serial, mech1, mech2"
q2 = "runtime, mechpg, shift"
fpmi.db.runQuery("select %s,%s from prodtrack where shift = 1"%(q1,q2))
Hope I have made my point clear and have a great day.