I'm developing an app with react native and SQLite to schedule daily events, but when I insert an event the id returns undefined.

In my database.js I have this:

CREATE TABLE IF NOT EXISTS events ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, description TEXT NOT NULL, date TEXT NOT NULL, hour TEXT NOT NULL ),

export function insertEvent(event) { const promise = new Promise((resolve, reject) => { database.transaction((tx) => { tx.executeSql( INSERT INTO events (title, description,date, hour) VALUES (?, ?, ?, ?), [ event.title, event.description, // Set up date event.date.toLocaleDateString(), // Set up hour with italian fuse format event.hour.toLocaleTimeString('it-IT', {hour: '2-digit', minute: '2-digit'}) ], (, result) => { resolve(result); }, (, error) => { r reject(error); } ); }); }); return promise; }

React Native with expo

Not sure what you mean, but:

• INSERT statements do not return IDs (unless you're using the new RETURNING clause?).
• Your "id" PK field cannot possibly ever be NULL or undefined.

Do you maybe mean you are querying the last_insert_rowid and it returns undefined? If so, how are you doing it? via the JS wrapper? in SQL? Do you do it from the same connection? Directly after inserting?

Please show the full SQL and/or code you use to do this, along with what you expect to see and what you actually see, else we're just guessing.

It returns an event in this mode: Event { "date": "1/8/2022", "description": "Test", "hour": "13:00", "id": undefined, "title": "Test", }

Select function: export function getEvents() { const promise = new Promise((resolve, reject) => { database.transaction((tx) => { tx.executeSql( SELECT * FROM events, [], (, result) => { const dbEvent = result.rows._array.map((row) => { return new Event(row.title, row.description, row.date, row.hour); }); console.log(dbEvent); resolve(dbEvent); }, (, error) => { reject(error); } ); }); }); return promise; }

Not 100% sure, and this is a JS question, not really an SQLite question, but from the looks of it your Event doesn't set the id at all.

i.e. this line:

            const dbEvent = result.rows._array.map((row) => {
              return new Event(row.title, row.description, row.date, row.hour);
            });

should it not be:

            const dbEvent = result.rows._array.map((row) => {
              return new Event(row.id, row.title, row.description, row.date, row.hour);
            });

?

Thank you very much, it now functions.