Examples of org.tmatesoft.sqljet.core.table.ISqlJetTable.order()

Class org.tmatesoft.sqljet.core.table.ISqlJetTable

Examples of org.tmatesoft.sqljet.core.table.ISqlJetTable.order()

org.tmatesoft.sqljet.core.table.ISqlJetTable.order()

Open cursors which sorts table by index.

If indexName is NULL then primary key will be used.

Cursors can be opened only within active transaction. When transaction ends all cursors will be closed.
@param indexName name of index which defines ordering.If null then primary keywill be used. @return cursor sorted by index. @throws SqlJetException


      try {
        table = podsalinanDB.getTable("podcasts");
        podsalinanDB.beginTransaction(SqlJetTransactionMode.READ_ONLY);
        if (table!=null){
          ISqlJetCursor currentDBLine = table.order(table.getPrimaryKeyIndexName());
          if (!currentDBLine.eof()){
            do {
              Podcast newPodcast = new Podcast(currentDBLine.getString("name"),
                               currentDBLine.getString("url"),
                               currentDBLine.getString("directory"),

View Full Code Here

                {
                    db.beginTransaction(SqlJetTransactionMode.READ_ONLY);
                    try
                    {
                        ISqlJetTable table = db.getTable("articles");
                        ISqlJetCursor cursor = table.order("published_article_index"/*table.getPrimaryKeyIndexName()*/);
                        long rowCount = cursor.getRowCount();
                        try
                        {
                            if( cursor.goToRow(index) == false )
                            {

View Full Code Here

0 1

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.