This was a great series! I like how the episodes are shorter because there are many things that if I'm confused about, I can go search outside and read to find out what it means/go deeper. Having the option of going deeper is more efficient to me than sitting through 1-2 hours of a lecture. Thanks so much!!!
I have watched many sqflite tutorials from youtube, But this channel is the best. Thank you sir, Very clear to understand your Step by step guides. SO Thank you,Thank you again. Now I have subscribed You
This lecture seemed rushed through ! Would have been better if we were presented "why" we are doing certain operations and benefits of doing them. There seem to be multiple ways of working with say routes. But why was the specific approach chosen in the lecture.
I wanted to just learn SQflite, but as a pre-req I had to watch all of his previous module 4 to finally regret at section 4.8 how badly its been walked through. Time totally not worth it; for a simple concept ended up spending hours of watching video.
Thanks once again Smartherd, You are a blessing to us all most especially me. please I will appreciate if one more session can be added to this tutorial to cover the null safety part that is just introduced by flutter. As it seems difficult to follow along if using the latest version of flutter. Please few minutes video tutorial will be appreciated explaining how to make the app function properly. thansk
When I am giving the title and descripition in 2nd screen and pressing Save I m directed to 1st screen which is fine but I am not able to see the card of note the screen is full blank as previous. Please help anyone!!!
Thanks you Smartherd! Being a Flutter developer beginer I gone through all vedios and all are very well explained. However I downloaded the source code from github for 8th video which is giving many build error. FYI, my Android Studio vesion is Android Studio Flamingo | 2022.2.1
Excellent work! A small question why it need this two lines to initialize database. getNoteList() itself initialize the database, no? 1: final Future dbFuture = databaseHelper.initializeDatabase(); 2: dbFuture.then((database) { Future noteListFuture = databaseHelper.getNoteList();
final notekeeper project not showing up the notes added in the main screen. Tried using smart nerd GitHub code also. Same issue . Everything is working but after clicking the save button the main screen appears to be plain. did anyone get the same issue?
Can we do this using provider? Hope it will be much easier then... I am confused with this tutorial..till the previous video i understand everything but this one is really confusing for me..
instead of priority i included roll no u set priority as 2 nd wen u chng it it gets changed but wen i set roll no. as 1 it is displaying tht only even after chnging the value
@smarherd Bro i am facing some issue getting(DatabaseException(table note_table has no column named date (code 1): , while compiling: INSERT INTO note_table (title, description, priority, date) VALUES (?, ?, ?, ?)) sql 'INSERT INTO note_table (title, description, priority, date) VALUES (?, ?, ?, ?)' args [cggf, cgugdfu, 2, Jan 20, 2019]}) error could you please help me to resolve this issue.
Hi, i have an issue and i hope you would be of help. I added some other priorities to the _priorities variable ... updated the updatePriorityAsInt() method and the getPriorityAsString() method, to reflect the new _priorities list. I also updated the getPriorityColor() method in the note_list.dart file, to reflect these changes. however, the drop down lists is only switching between High and Low priorities. Please could you help ?
Can u plzz help me I am trying to find how to solve this error from 3 days but to no avail. I am getting this error when i click save button The setter 'firstName=' was called on null. Receiver: null Tried calling: firstName="J" The setter 'firstName=' was called on null. Receiver: null Tried calling: firstName="Ja" like this for all the textfields used. I am trying out an app watching ur tutorial n m stuck here. Please do help me. How to solve this error.
Due to Null Safety in the latest version of Flutter, my application gets crashes when I press FAB and gives this error "expected a value of type string but got one of type null " at "return NoteDetail(note, title);" in note_list.dart file . Does anyone know how to resolve this?
Nice tutorial. I have few questions in it. If a item is deleted or added, is it a good approach to fetch all the items again. And I should be able fetch 10-10 items rather than fetching all items. It might create an issue if note list will be 1000 or more. Thanks
Edit: my bad it was a typo i missed the _ on the model i get this error, im not sure why, Future and awaits already there Exception has occurred. NoSuchMethodError (NoSuchMethodError: The method 'query' was called on null. Receiver: null Tried calling: query("note_table", orderBy: "priority ASC"))
What is the solution of this Error: MissingPluginException(No implementation found for method getApplicationDocumentsDirectory on channel plugins.flutter.io/path_provider)
While running the app, at the initial stage ,I am getting following error. Syncing files to device Redmi Note 5 Pro... I/flutter (20894): ══╡ EXCEPTION CAUGHT BY WIDGETS LIBRARY ╞═══════════════════════════════════════════════════════════ I/flutter (20894): The following NoSuchMethodError was thrown building NoteList(dirty, state: _NoteListState#e9138): I/flutter (20894): The method 'initializeDatabase' was called on null. I/flutter (20894): Receiver: null I/flutter (20894): Tried calling: initializeDatabase() Pls tell me solution..
I was having the same errors where the save button just wasn't working. After carefully going through the code I realized that it was because of a typo when creating the database causing there to be an error, here's how it should be: void _createDb(Database db, int newVersion) async { await db.execute('CREATE TABLE $noteTable ($colId INTEGER PRIMARY KEY AUTOINCREMENT, ' '$colTitle TEXT, $colDescription TEXT, $colPriority INTEGER, $colDate TEXT)'); } In the video he used "helper" out of nowhere, what you have to do is similar to the note_list.dart, you've got to access it on note_detail.dart, Add this in your extended State: DatebaseHelper helper = DatabaseHelper(); Hope this helps ^^ On a final note be sure if you're running it on your Android phone directly to have migrated to AndroidX. Happy coding and Happy New Year's!! ^o^
i have made these chnges its wrking fine on emulator but when i build apk and run it on my mobile phone i am not able to view the list after saving the data the screen is blank
Erroe in WillPopScope, The function has return type Future ,but does not end with return statement . file name: note_detail.dart [45,17]. Same error in my code and and code downloaded from github.
Good video but for beginner its going to be little difficult to absorb. Instead of writing all methods like a big bang, you could have written code solution feature wise. Like first populate all task list via select query, then move on to delete button & delete query.. accordingly this way learns able to see the result of every method action.
@@lakshandersagwal I felt this tutorial is pulling the motivation down. I purchashed a udemy course and finished the sqflite in 2 hours. Happy to share code or link to the tutorial
I am getting this error. on a red screen The getter 'firstName' was called on null. Receiver: null Tried calling: firstName Can u help me by telling y i m getting this error n how can i solve it plzzzzzz I learnt flutter watching ur video n m trying to develop an app for my clg project. Now I am stuck here from 3 days. plzz help me
I can't view the insert in the list because it is not update. for solve it bug. you can insert in note_list.dart into NoteListState @override void initState() { // TODO: implement initState updateListView(); //forzar a que liste el elemento recién creado super.initState(); } When the app return to firstScreen the list would be update :)
While trying to save, I am getting an error message like this. Please suggest. [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: DatabaseException(table note_table has no column named date (code 1 SQLITE_ERROR): , while compiling: INSERT INTO note_table (title, description, priority, date) VALUES (?, NULL, ?, ?)) sql 'INSERT INTO note_table (title, description, priority, date) VALUES (?, NULL, ?, ?)' args [, 2, Feb 9, 2020]}
When i add or delete note object in delete view it directs to note_list view so here the note_list is not updated on the spot. But when i close and reopen the app, i can see the updated content in note_list. whats the problem here?
Erroe in WillPopScope, The function has return type Future ,but does not end with return statement . file name: note_detail.dart [45,17]. Same error in my code and and code downloaded from github. Please Reply.
So I am facing a problem if anybody can help. For Some Reason,only the 'priority' instance variable of the Note class seems to not be getting inserted and updated in the database. Rest all are working fine. When I checked through debugPrint() the value of priority in 'NoteDetail ' class, it shows 'null'. (As a result all my notes are by default of 'null' priority and of yellow background) Using debugPrint(), I have checked, right upto just before the point where database is Inserted & Updated and I have got proper values for priority(ie 1or 2). Only when I check it on retrieval, does it show 'null'. I am using the same functions db.insert() and db.update() as @Smartherd for Insertion and Updation. I also tried adding note.priority to whereArgs attribute in db.update(), but to no avail. Can Anybody guess where the problem lies. Thanks.
@@lakshandersagwal Nope. I tried certain things (for example using the rawInsert() function) but they resulted in different kind of errors(Run Time Exceptions). I am only a beginner in Flutter so don't know much what else to try. 🤷♂️
void navigateToDetail(Note note, String title) async{ int? result = await Navigator.push(context, MaterialPageRoute(builder: (context){ return NoteDetail(note, title); })); if(result == true){ updateListView(); } } The following _CastError was thrown building NoteDetail(dirty, dependencies: [_InheritedTheme, _LocalizationsScope-[GlobalKey#44e71]], state: NoteDetailState#02499): Null check operator used on a null value plz give me this problems solution.
pls make a tutorial on how to add a note to each listview item. for example, the constitution of india. when you click an article you can either highlight or add notes no need for another screen just pop up
Error running Gradle: ProcessException : process "c:\users\appname\ Android\gradlew.bat " excited abnormally: > Configure project: sqflite Iam getting this error continuously If anyone knows about this error ..pls tell how to solve. Thanks in advance
got these error from the source code: I/flutter ( 9786): ══╡ EXCEPTION CAUGHT BY WIDGETS LIBRARY ╞═══════════════════════════════════════════════════════════ I/flutter ( 9786): The following assertion was thrown building Builder(dirty): I/flutter ( 9786): Looking up a deactivated widget's ancestor is unsafe. I/flutter ( 9786): At this point the state of the widget's element tree is no longer stable. To safely refer to a I/flutter ( 9786): widget's ancestor in its dispose() method, save a reference to the ancestor by calling I/flutter ( 9786): inheritFromWidgetOfExactType() in the widget's didChangeDependencies() method.
This video lecture was too fast and need to watch again and again for understanding.. In this you perform all tasks well but did not teach as much as you can.
10 mins past and the code is not executed even once.. just code code code and code.. finally get lost ... Please seriously consider making tutorials that is bit sized, absorbed and relatable to learners.
int result = await helper.deleteNote(note.id); int result = await databaseHelper.deleteNote(note.id); error: The argument type 'int' can't be assigned to the parameter type 'Note'. (argument_type_not_assignable at [database] lib\screens ote_list.dart:116)
In database_helper.dart, you would have in the method deleteNote like this: Future deleteNote(int id). it´s possible that you have in the parameter (Note note)