I use ionic4 + angular8 code flow:
Error code:
Please help me. Thank you.
error code in here enter image description here
-
webService.service.ts and storageService.service.ts are 2 files that you created right ?can you post 2 file webService.service.ts and storageService.service.ts ?Khanh Le Tran– Khanh Le Tran2020-02-17 03:46:19 +00:00Commented Feb 17, 2020 at 3:46
-
webService.service.ts和storageService.service.ts？ no problem. subject matter is sqlitesamrtian– samrtian2020-02-17 04:42:42 +00:00Commented Feb 17, 2020 at 4:42
Add a comment
|
2 Answers
You have written transaction but, I let you know that there is no property of transaction in SQLite plugin, you need to add write create property, whatever to open or create the database. like =>
this.sqlite.create({
name: 'data.db',
location: 'default'
})
.then((db: SQLiteObject) =>
db.executeSql('create table danceMoves(name VARCHAR(32))', [])
.then(() => console.log('Executed SQL'))
.catch(e => console.log(e));
})
.catch(e => console.log(e));
Comments
When you open or create db from sqlite , you should use executeSql after to execute query and take action with db. Sqlite for ionic 4 doesn't support transaction anymore. For more information and example
this.sqlite.create({
name: 'data.db',
location: 'default'
})
.then((db: SQLiteObject) => {
db.executeSql('create table danceMoves(name VARCHAR(32))', [])
.then(() => console.log('Executed SQL'))
.catch(e => console.log(e));
})
.catch(e => console.log(e));
