Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Inserting or Modifying Rows

JChem provides the chemaxon.jchem.db.UpdateHandler class for updating and inserting rows in structure tables. A structure table contains fixed columns (cd_...) and, optionally, additional columns that have been defined explicitly.
Java example:

...

Anchor
delete_rows
delete_rows

Deleting Rows

The deleteRows method of the UpdateHandler class is suggested for deleting rows from structure tables. It also increments updateCounter for the given table in JChemProperties, which is important when caching is used during structure search.
Example:

...

Other Methods

Other useful methods of UpdateHandler:

getStructureTables

Retrieves the name of all structure tables.

createStructureTable

Creates a structure table.

dropStructureTable

Removes a structure table.

...