wwUtils::FlattenSql

Flatten a SQL command that contains CHR(13) or CHR(10) characters into a single line by stripping out the CR/LF values and replacing them with a space.

Useful in code so you can write SQL expressions using multi-line SQL between TEXT and ENDTEXT.

For example:

TEXT TO lcSql NOSHOW
SELECT id, title, description
    FROM albums
    ORDER BY title
ENDTEXT

* &lcSql   && fails

lcSql = FlattenSql(lcSql)

&lcSql   && works
o.wwUtils.FlattenSql(lcSql)

Parameters

lcSql
A SQL String that can contain CR/LF characters, that are turned into spaces.


See also:

Class wwUtils

© West Wind Technologies, 2023 • Updated: 03/21/21
Comment or report problem with topic