Error adding row to sqlite database using Appcelerator Titanium

Question

I've created a HTML/JS project in Titanium to develop a desktop app, and have the following code to add data to a sqlite table:

var db = Ti.Database.install('/data/', 'fyw');
db.execute('INSERT INTO newtable (col1, col2, col3, col4) VALUES (?,?,?,?)', 'col1', 'col2', 'col3', 'col4');
Titanium.API.info('JUST INSERTED, lastInsertRowId = ' + db.lastInsertRowId);
db.close();

The code is wrapped in a try...catch and the error I get is "undefined". How can I add a row, then get the id (it's an autoincrement field) which I need to use further down the code?

Thanks,

Adrian

Richard Kingsley · Accepted Answer · 2011-02-04 15:48:39Z

2

Haven't tried it myself in titanium, but you could use the maxid sql to get the last row index and use that instead further down the script.

SELECT max(id) FROM table etc

Hope that helps a bit

answered Feb 4, 2011 at 15:48

Richard Kingsley

361 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Adrian Johnson Over a year ago

Thanks Richard. Never thought of doing it that way.

Collectives™ on Stack Overflow

Error adding row to sqlite database using Appcelerator Titanium

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related