Examples for 'DBI::sqlCommentSpec'


Parse interpolated variables from SQL.

Aliases: sqlCommentSpec sqlQuoteSpec sqlParseVariablesImpl sqlParseVariables

Keywords: internal

### ** Examples

# Use [] for quoting and no comments
sqlParseVariablesImpl("[?a]",
  list(sqlQuoteSpec("[", "]", "\\", FALSE)),
  list()
)
$start
integer(0)

$end
integer(0)
# Standard quotes, use # for commenting
sqlParseVariablesImpl("# ?a\n?b",
  list(sqlQuoteSpec("'", "'"), sqlQuoteSpec('"', '"')),
  list(sqlCommentSpec("#", "\n", FALSE))
)
$start
[1] 6

$end
[1] 7

[Package DBI version 1.1.2 Index]