2518372 - Application query fails with Conditional Statements that shouldn't be executed Msg233, 515 - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2518372 - Application query fails with Conditional Statements that shouldn't be executed Msg233, 515 - SAP ASE

Symptom

  • SQL query fails when it should not be executed:
    if @value is not null
    begin
       insert into #testcase(column1) values(@value)
    end
  • Error:
    Msg 233, Level 16, State 1:
    Server 'asename', Line 4:
    The column c1 in table testcase does not allow null values. 

Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • SAP Adaptive Server Enterprise (ASE)
  • jConnect
    • JDBC 7.0
    • JDBC 7.07
    • JDBC 16
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • Adaptive Server Enterprise ADO.NET Data Provider
    • 3.5 Provider ( Sybase.AdoNet35.AseClient.dll )
    • 4.0 Provider ( Sybase.AdoNet4.AseClient.dll )
    • 4.5 Provider ( Sybase.AdoNet45.AseClient.dll )
  • java
  • odbc
  • .Net

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Software Developer Kit 15.7

Keywords

error, wrong, incorrect, validate, validation, if, for, loop, clause, command, sql, t-sql, script, execute, fail, default, exception , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.