Praktek Membuat Aplikasi Daftar Absensi & Setup SQLite + Flutter

[Aris Sugiyono]

I/flutter ( 5675): ‘ args [] during open, closing…
E/flutter ( 5675): [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: DatabaseException(near “nama”: syntax error (code 1 SQLITE_ERROR): , while compiling: CREATE TABLE absensi (
E/flutter ( 5675): id INTEGER PRIMARY KEY AUTOINCREMENT
E/flutter ( 5675): nama TEXT,
E/flutter ( 5675): status_hadir TEXT,
E/flutter ( 5675):
E/flutter ( 5675): )) sql ‘ CREATE TABLE absensi (
E/flutter ( 5675): id INTEGER PRIMARY KEY AUTOINCREMENT
E/flutter ( 5675): nama TEXT,
E/flutter ( 5675): status_hadir TEXT,
E/flutter ( 5675):
E/flutter ( 5675): )
E/flutter ( 5675): ‘ args []
E/flutter ( 5675): #0 wrapDatabaseException (package:sqflite/src/exception_impl.dart:11:7)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #1 SqfliteDatabaseMixin.txnSynchronized (package:sqflite_common/src/database_mixin.dart:485:16)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #2 DbHelper._createDb (package:absensi_app_sqlite_130924/helpers/dbhelper.dart:32:5)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #3 SqfliteDatabaseMixin.doOpen.<anonymous closure> (package:sqflite_common/src/database_mixin.dart:1006:19)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #4 SqfliteDatabaseMixinExt._txnTransaction (package:sqflite_common/src/database_mixin.dart:337:16)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #5 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:33:16)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #6 SqfliteDatabaseMixin.txnSynchronized (package:sqflite_common/src/database_mixin.dart:517:14)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #7 SqfliteDatabaseMixin.doOpen (package:sqflite_common/src/database_mixin.dart:995:13)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #8 SqfliteDatabaseOpenHelper.openDatabase (package:sqflite_common/src/database.dart:46:7)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #9 SqfliteDatabaseFactoryMixin.openDatabase.<anonymous closure> (package:sqflite_common/src/factory_mixin.dart:112:18)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #10 ReentrantLock.synchronized.<anonymous closure> (package:synchronized/src/reentrant_lock.dart:37:18)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #11 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:33:16)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #12 DbHelper.database (package:absensi_app_sqlite_130924/helpers/dbhelper.dart:45:19)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #13 DbHelper.create (package:absensi_app_sqlite_130924/helpers/dbhelper.dart:60:19)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675): #14 _homePageState._createAbsensi (package:absensi_app_sqlite_130924/ui/homePage.dart:85:18)
E/flutter ( 5675): <asynchronous suspension>
E/flutter ( 5675):

[Aris Sugiyono]

error seperti di atasa dan tidak menyimpan coach

[Aris Sugiyono]

https://github.com/arissugiyono/absensi_sederhana.git

[Coach Jani]

hallo aris sugyono.
itu disaat insert data ya
1. silahkan lihat di file model absensi baris 13 rubah

int get id → _id!; menjadi int? get id → _id; karna ketika insert id ini tdk perlu diisi atau autoincrement

2. silahkan di function _deleteAbsensi di file homepage.dart id nya tidak boleh null. silahkan beri yanda !

int result = await dbHelper.delete(object.id!);

selamat mencoba
salam flutter

[Aris Sugiyono]

masih belum bisa coach. mohon di cek code di github saya
https://github.com/arissugiyono/absensi_sederhana.git

[Aris Sugiyono]

sudah done coach. terima kasih

[Okta savira]

sama sama kak aris

[Author]

Posts