List of updateNull() Examples

Examples of updateNull()

com.sun.star.sdb.XColumnUpdate.updateNull()
java.sql.ResultSet.updateNull()
Updates a column specified by a column index with a null value. @param columnIndex the index of the column to update @throws SQLException if a database error happens
javax.sql.rowset.spi.SyncResolver.updateNull()

Examples of com.sun.star.sdb.XColumnUpdate.updateNull()

            XNameAccess xCols = xSuppCols.getColumns();


            // and update the date column with a NULL value
            XColumnUpdate xDateColumn = (XColumnUpdate)UnoRuntime.queryInterface(
              XColumnUpdate.class, xCols.getByName( "SALEDATE" ) );
            xDateColumn.updateNull();




            // then restore the flag
            xFormProps.setPropertyValue( "IsModified", aModifiedFlag );
          }

View Full Code Here

Examples of com.sun.star.sdb.XColumnUpdate.updateNull()

            XNameAccess xCols = xSuppCols.getColumns();


            // and update the date column with a NULL value
            XColumnUpdate xDateColumn = (XColumnUpdate)UnoRuntime.queryInterface(
              XColumnUpdate.class, xCols.getByName( "SALEDATE" ) );
            xDateColumn.updateNull();




            // then restore the flag
            xFormProps.setPropertyValue( "IsModified", aModifiedFlag );
          }

View Full Code Here

Examples of com.sun.star.sdb.XColumnUpdate.updateNull()

            XNameAccess xCols = xSuppCols.getColumns();


            // and update the date column with a NULL value
            XColumnUpdate xDateColumn = (XColumnUpdate)UnoRuntime.queryInterface(
              XColumnUpdate.class, xCols.getByName( "SALEDATE" ) );
            xDateColumn.updateNull();




            // then restore the flag
            xFormProps.setPropertyValue( "IsModified", aModifiedFlag );
          }

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

            assertEquals("java.io.Reader", meta.getColumnClassName(15));
            assertEquals("java.io.InputStream", meta.getColumnClassName(16));
        }
        rs.moveToInsertRow();
        rs.updateInt(1, 0);
        rs.updateNull(2);
        rs.updateNull("DEC");
        // 'not set' values are set to null
        rs.insertRow();


        rs.moveToInsertRow();

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

            assertEquals("java.io.InputStream", meta.getColumnClassName(16));
        }
        rs.moveToInsertRow();
        rs.updateInt(1, 0);
        rs.updateNull(2);
        rs.updateNull("DEC");
        // 'not set' values are set to null
        rs.insertRow();


        rs.moveToInsertRow();
        rs.updateInt(1, 1);

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

        ResultSet rs = s.executeQuery("select * from t1");
        rs.absolute(5);
        final int oldCol2 = rs.getInt(2);
        final int oldCol3 = rs.getInt(3);
        
        rs.updateNull(2);
        assertEquals("Expected the resultset to be updated after updateNull",
                     0, rs.getInt(2));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        rs.cancelRowUpdates();
        assertEquals("Expected updateXXX to have no effect after cancelRowUpdated",

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

                     0, rs.getInt(2));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        rs.cancelRowUpdates();
        assertEquals("Expected updateXXX to have no effect after cancelRowUpdated",
                     oldCol2, rs.getInt(2));
        rs.updateNull(2);
        assertEquals("Expected the resultset to be updated after updateNull", 
                     0, rs.getInt(2));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        assertTrue("Expected rs.rowUpdated() to be false before updateRow", 
                   !rs.rowUpdated());

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

        assertTrue("Expected rs.rowUpdated() to be true after updateRow", 
                   rs.rowUpdated());
        assertEquals("Expected the resultset detect the updates of previous " + 
                     "updateRow", 0, rs.getInt(2));
        
        rs.updateNull(3);
        
        assertEquals("Expected the resultset to be updated after updateNull", 
                     0, rs.getInt(3));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        assertEquals("Expected the resultset detect the updates of previous " +

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

        
        assertEquals("Expected updateXXX to have no effect after " +
                     "cancelRowUpdated", oldCol3, rs.getInt(3));
        assertEquals("Expected the resultset detect the updates of previous " +
                     "updateRow after cancelRowUpdated", 0, rs.getInt(2));
        rs.updateNull(3);
        rs.updateRow();
        assertEquals("Expected the resultset to be updated after updateNull", 
                     0, rs.getInt(3));
        rs.cancelRowUpdates();

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

        ResultSet rs = s.executeQuery("select * from t1");
        rs.absolute(5);
        final int oldCol2 = rs.getInt(2);
        final int oldCol3 = rs.getInt(3);
        
        rs.updateNull(2);
        assertEquals("Expected the resultset to be updated after updateNull",
                     0, rs.getInt(2));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        rs.cancelRowUpdates();
        assertEquals("Expected updateXXX to have no effect after cancelRowUpdated",

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.