B4J Question [BANano] For BANanoSQL, is there something like "rowid" for SELECT?

[Mashiane]

Hi there

Is it possible to return the "rowid" in BANanoSQL when doing SELECT calls?

Thanks.

 

[alwaysbusy]

I do not understand what you're asking. If you have a rowid (e.g. with autoincrement) in your table, why don't you just add it to the fields you want in your select? SELECT rowid, ... FROM mytable

Alwaysbusy

 

[Mashiane]

With SQLite for example, well not sure if BANanoSQL does it, if you dont specify an auto-increment field explicitly, it creates a rowid, or rather the better wording, without specifying 'WITHOUT ROWID'

For example

CREATE TABLE people (   first_name TEXT NOT NULL,   last_name TEXT NOT NULL );

Then insert

INSERT INTO people (first_name, last_name) VALUES('Anele', 'Mbanga');

Then select

SELECT   rowid,   first_name,   last_name FROM   people;

Ohh, now I see I was not thinking, it now makes sense, whatever field you define as a primary auto-increment, it is just an alias to rowid.