Stack Overflow
Stack Overflow

Questions tagged [rowid]

210 questions
4
votes
1 answer

rowid in SQLITE3 and Android

I perform an insert on a database and I want to know what the rowid is for that insert. Does this accomplish the task: Uri uri = ContentResolver.insert(url,values); //Make insert int rowid= Integer.parseInt(uri.getFragment()); //Get rowid The…
user817129
  • 522
  • 3
  • 10
  • 19
4
votes
1 answer

INTEGER PRIMARY KEY vs rowid in SQLite

I am trying to import some spatial data (OSM) into an SQLite database. The SQLite reference states that an INTEGER PRIMARY KEY becomes an alias for the rowid (if WITHOUT ROWID is not specified). Just to be sure, I created my main table in two…
JayTee
  • 163
  • 1
  • 6
4
votes
2 answers

how to get last inserted row id in sqlite

function insertToProject(cast, pName) { db.execute('INSERT INTO project (cd, pn) VALUES (?,?)', cast, pName); var x = last_insert_rowid(); return x; } I have been trying this using javascript in titanium appcelerator. Can…
nitin
  • 571
  • 1
  • 4
  • 16
3
votes
0 answers

How to get/utilize SQLite row ID reliably with C API when user hide all the column names?

According to SQLite documentation, All tables have rowid by default, and it cannot be removed. And this rowid can be accessed with rowid, oid or _rowid_. Anyway database users can add the new column with the names freely, and the columns will be…
eonil
  • 83,476
  • 81
  • 317
  • 516
3
votes
3 answers

Is there an open-source SQL database that has the concept of Oracle's "rowid" pseudo-column?

I am aware that MySQL and PostgreSQL[1] do not have that concept, so I am interested in finding out of there is an open-source SQL database that does have the concept. [1] It was later pointed out that PostgreSQL does have the rowid pseudo-column.
James Mishra
  • 4,249
  • 4
  • 30
  • 35
3
votes
5 answers

HOW TO get records with given rowid list IN STRING from a table (Oracle)?

Any one can help me to resolve the FIXME ? -- Task: Get records with given rowid IN STRING from a table. -- NOTICE: I do not known where the given rowid comes from. -- OUTPUT 'AAAAB0AABAAAAOhAAA' SELECT ROWID FROM DUAL; -- OK, one record SELECT *…
btpka3
  • 3,720
  • 2
  • 23
  • 26
3
votes
1 answer

Oracle ROWID as function/procedure parameter

I just would like to hear different opinions about ROWID type usage as input parameter of any function or procedure. I have normally used and seen primary keys used as input parameters but is there some kind of disadvantages to use ROWID as input…
Jokke Heikkilä
  • 918
  • 1
  • 8
  • 17
3
votes
3 answers

Selecting one row from sqlite database using rawQuery and rowid in Android

I've created an external SQLite database that looks something like this: What I want to do in my Android application is to load all the values from one row using ROWID and put them into array. For example: Cursor cursor = db.rawQuery("SELECT * FROM…
Chilcone
  • 301
  • 1
  • 4
  • 7
3
votes
2 answers

How oracle rowid is generated internally?

I want to know, does the ROWID in oracle get generated incrementally? If I try below query select min(ROWID) from table will I always get the ROWID of first inserted row in the table or I may end up getting a ROWID OF any random row also? It would…
Nitin_Sen
  • 331
  • 3
  • 5
  • 10
3
votes
1 answer

Sqlite3 rowid vs. AUTOINCREMTENT

Im working on my second project with sqlite3 and have a question. What is the difference between working with rowid and/or working with own AUTOINCREMENT INTEGER value? Is one of both better/faster than the other?
mr_app
  • 1,292
  • 2
  • 16
  • 37
2
votes
1 answer

How does one reformat an SQLite database so that the rowIds equal the placement on the table and when a row is deleted lower rows move up

I have recently come across a point where I need a database to do the above. I have looked online and have not found something that solves the problem and I understood. Another way to phrase the above question is "how could I make the rows always in…
jersam515
  • 657
  • 6
  • 22
2
votes
5 answers

How to use ROWID with an Oracle Join View

I am trying to create a unique identifier for every row of a view. The view I have joins a lot of tables and therefore no one table's primary key will help me identify the row. Doing a google search it looks like I may be able to achieve this by…
user973479
  • 1,629
  • 5
  • 26
  • 48
2
votes
2 answers

ag-grid: Using Javascript, find the row id for a given data

I have a list of employees and I want to find the “id” of the row where firstName=Bob which is unique. In other words, I know the firstName supplied as “Bob” and now, I just need to find the row id using Javascript for ag-grid. According to the…
Jay
  • 744
  • 4
  • 14
  • 30
2
votes
1 answer

How to retrieve rowId of a particular listitem of filtered listview in listActivity displaying SQlite data?

Hello Everyone I am new being in ANDROID so I am getting one problem during developing an app using SQLite database. I retrieved some data columns from SQLite database table, stored them in an ArrayList and displayed them using ListActivity. Then I…
Pradeep Menon
  • 163
  • 1
  • 12
2
votes
4 answers

SQL to return the rownum of a specific row? (using Oracle db)

In Oracle 10g, I have this SQL: select dog.id as dogId from CANINES dog order by dog.codename asc which returns: id -- 204 203 206 923 I want to extend this query to determine the oracle rownum of a dog.id in this resultset. I have tried select…
jedierikb
  • 12,752
  • 22
  • 95
  • 166
1
2
3
…
13 14