sqlite - How to set the ID number to 1 in an Android SQL query -


i trying query on table in android sqlite. when query table want id number start 1 , increment every row. however, when query on table @ moment, it's showing id number of original table table. suggestions appreciated.

      private static string[] = {_id, title, date, time, details}; private static string order_by = time + " asc";  private cursor getappointments() {     sqlitedatabase db = appointments.getreadabledatabase();     cursor cursor = db.query(table_name, from, date + "=?", new string[] {date}, null, null, order_by, null);     startmanagingcursor(cursor);     return cursor; }  }

typically, should not concerned value of id, other it's unique , identifies row.

if define table column _id primary key unless if set _id, start 1 when insert first row, next 2 , 3 etc.

if code autoincrement though, may not case, autoincrement make value unique @ database level.

here's extract sqlite autoincrement

the autoincrement keyword imposes cpu, memory, disk space, , disk i/o overhead , should avoided if not strictly needed. not needed.

in sqlite, column type integer primary key alias rowid (except in without rowid tables) 64-bit

signed integer.

on insert, if rowid or integer primary key column not explicitly given value, filled automatically

unused integer, 1 more largest rowid in use. true regardless of whether or not autoincrement keyword used.

if autoincrement keyword appears after integer primary key, changes automatic rowid assignment algorithm prevent

reuse of rowids on lifetime of database. in other words, purpose of autoincrement prevent reuse of rowids deleted rows.

i'm assuming don't have expectation _id dynamically change order of extracted rows after query, how question interpreted per

when query table want id number start 1 , increment every row

if question, wouldn't this, rather you'd loop through cursor, ordered according query. if wanted first referenced 1, 2, 3.... loop though cursor creating associated array such number.


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more