Flutter Sqlite , select one result from database table

Question

I'd like know , isn't possible to select just one row from database using Flutter and Sqlite ?

I have tried this code :

// db.dart
Future<dynamic> find(Note note) async {
   await openDb();
   return await _database.query('note', where: "id = ?", whereArgs: [note.id], limit: 1);
}

// detail.dart
// note is an object
final noteO = dbmanager.find(note);
print(noteO);

the output of print(noteO) in console is :

I/flutter ( 8845): Instance of 'Future<dynamic>'

F Perroch · Accepted Answer · 2020-04-16 21:35:39Z

2

The final noteO = dbmanager.find(note); give you a Future<dynamic>.

If you want to get the result of your query, you need to put the await keyword :

final noteO = await dbmanager.find(note);

answered Apr 16, 2020 at 21:35

F Perroch

2,2552 gold badges14 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Flutter Sqlite , select one result from database table

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related