"Cecil Westerhof"  wrote in message news:87a8rsnkmw....@equus.decebal.nl...

This has got nothing to do with your question (which I found interesting) but I thought I would mention it.

export_spreekwoorden is defined as:
export_spreekwoorden        = '''
    SELECT      spreekwoord
    FROM        spreekwoorden
    ORDER BY    spreekwoord COLLATE LOCALIZED
'''

This works fine, but if anyone examines the resulting sql, it is full of extra spaces and newlines.

To avoid this, I have adopted this habit -

export_spreekwoorden = (
   "SELECT spreekwoord "
   "FROM spreekwoorden "
   "ORDER BY spreekwoord COLLATE LOCALIZED"
   )

To my eye, the result is nicer, at virtually no extra effort. Just don't forget the trailing space on all but the last line.

Frank Millman


--
https://mail.python.org/mailman/listinfo/python-list

Reply via email to