removeFromSequence

Description

Removes the index-th value from the attribute associated with the SEQUENCE constraint on the CUBRIDOID instance.

Syntax

void removeFromSequence(String attrName, int index)

Example

//create class foo(c list of int  )

//insert into foo values(1,3)

 

String sql = "select foo from foo" ;

 

Connection con = DriverManager.getConnection(url,user,passwd);

 

Statement stmt = con.createStatement();

CUBRIDResultSet rs = (CUBRIDResultSet) stmt.executeQuery(sql);

 

while (rs.next ()) {

   CUBRIDOID oid = rs.getOID(1);      // get OID

   oid.removeFromSequence("c",1);     // c: {1,3} -> {3}

}