Acknowledging Defects

From SQLBWiki

Jump to: navigation, search
  • Sometimes, SQLBrowser reports a defect that you know about but that you can not or do not want to address.
  • You can 'acknowledge' such defects.
  • To do this, insert a pragma in the form of a comment just before the statement which generates the defect.


The pragma has the following syntax: 

 -- pragma acknowledge next defect <DEFECTCODE>

example: 

 -- pragma acknowledge next defect QAFM
 select @id_ccy = id_currency
 from narval..currency where 
 cd_iso_ccy = @cd_iso_ccy


  • The defect will then appear differently (ticked) in both the editor and in the batch analysis
  • You can untick 'Detect acknowledged defects' in the Option / Defects pane to stop detection of such defects
  • The list of defect codes is here
Retrieved from "http://www.sqlbrowser.com/wiki/index.php/Acknowledging_Defects"