Hi,
My customer want's to be able to pass column names that contain the '.' character . Even when quoted, it seems HXTT is parsing this as a table name separator.
e.g. "col1.name" will be treated as column 'name' is in table 'col1'. Is there a way to escape the '.' character within a column such that it is not parsed as a table identifier separator?
Thanks,
Mark
|
Supported. For instance, SELECT a.one,"a.one",TEST2."a.one",* FROM TEST2;
But " character to quote is preferable since you maybe meet trouble for join table sometimes without ".
Please download the latest package.
|