List of insertByFieldNamesOr() Examples

Examples of insertByFieldNamesOr()

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

Insert record by values by names of fields.

If table have INTEGER PRIMARY KEY column then this column could be null or even not specified and in this case it value will be defined automatically.

The ROWID of record could be passed by any of this names: ROWID, _ROWID_, OID. ROWID could be specified even if table haven't INTEGER PRIMARY KEY column.

All relevant indexes are updated automatically.

Returns ROWID of inserted record.

Can be used without of active transaction, in this case method begins and ends own internal transaction.

Implements ON CONFLICT clause. See {@link SqlJetConflictAction}.

@param onConflict {@link SqlJetConflictAction}. @param values Values for the new record. @return ROWID of inserted record. @throws SqlJetException

            
            Map<String,Object> fields = new HashMap<String, Object>();
            fields.put("key", fp.getUserTitle() );
            fields.put("title", fp.getTitle() );
                    
            long rowid = table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, fields);
            
            db.commit();
            return true;
        }         
        catch(Exception ex)

                rowid = table.insertByFieldNames(fields);
            }
            else
            {
                fields.put("new_entry", Boolean.FALSE.toString());
                rowid = table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, fields);
            }
            
            db.commit();
            return true;
        }

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.

Examples of insertByFieldNamesOr()

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

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