SQL Comment delimiter in XDBC

Forum|Forum|12 years ago
February 15, 2013
0 replies
0 views

Dominique Sacre
Rocketeer

Problem:

Some databases support the usage of "--" or {}. Using either to include a comment in an SQL statement executed by XDBCquery generates a syntax error.

Resolution:

Use the "#" as a comment delimiter.

Old KB# 2846