Product Documentation

c-treeACE V10.3 Release Notes

Previous Topic

Next Topic

c-treeACE SQL Explorer and c-treeACE Explorer - Comment chars in quotes 'xx--'

c-treeACE SQL Explorer and c-treeACE Explorer were updated to properly handle comment characters in quotation marks.

In a statement similar to the following the -- characters (which usually mean the start of a comment) must be ignored since they are inside quotation marks:

select * from trans_codes where rawtranscode = 'AA--'

The tool was not ignoring them and instead was stripping them and running :

select * from trans_codes where rawtranscode = 'AA

The logic has been adjusted to properly handle such cases.

TOCIndex