create
void _onCreate(Database db, int version) async {
await db.execute("CREATE TABLE " +
TASK_TABLE_NAME +
" ("
"id STRING PRIMARY KEY, "
"tasktype TEXT, "
"tasktitle TEXT, "
"taskdescription TEXT, "
"taskcompleted TEXT, "
"datetime TEXT, "
"datetimedue TEXT, "
"taskpriority TEXT)");
}
add
newTask(newTask) async {
var dbClient = await db;
var result = await dbClient.rawInsert(
"INSERT INTO " +
TASK_TABLE_NAME +
" ("
"id STRING PRIMARY KEY, "
"tasktype TEXT, "
"tasktitle TEXT, "
"taskdescription TEXT, "
"taskcompleted TEXT, "
"datetime TEXT, "
"datetimedue TEXT, "
"taskpriority TEXT) VALUES (?, ?, ?, ?, ?, ?, ?, ?)",
[
newTask.datetime,
newTask.taskType,
newTask.taskTitle,
newTask.taskDescription,
newTask.taskCompleted,
newTask.datetime,
newTask.datetimedue,
newTask.taskPriority
]);
return result;
}
no types allowed there
types are all in the create table stratement.
so it should be more like task_table_name + “(id, tasktype, tasktitle …) values ( … )"
Hello! I have created another video about "WillPopScope & BackButton - Navigate Back Android - Flutter" https://www.youtube.com/watch?v=do5Ppu7Nfpg 
my advice is based on just sqlite.
I’d also recommend https://flutter.dev/docs/cookbook/persistence/sqlite
thank you c:
rawinsert is inserting the data into the database right?
yeah, your syntax matches
int id2 = await txn.rawInsert(
'INSERT INTO Test(name, value, num) VALUES(?, ?, ?)',
['another name', 12345678, 3.1416]);
print('inserted2: $id2');
});
from the official doc
If any method is marked async, or uses the explicit Future/Stream protocol, everything that invokes it (and recursively) must also be non-blocking.
yeetmeokayimdead2222 what is future/stream?
yeetmeokayimdead2222 um
yeetmeokayimdead2222 thanks again
So many things I am trying to do dont work without explanation
=$
yeetmeokayimdead2222 what does flutter mean in a business
I am trying to control the state in a series of children from the main thread which is reading multicast data. The only way I have found to do this is to create a thread with a receive port, that sends its sendPort to the main thread an the main thread passes that sendport to each child widget, and those child widgets create receive ports and send their send ports to that main receive port
very convoluted
Getting hung up on the fact that Statefulwidgets constructors are synchronous and cant synchronize an asynchronous call
*gasp
yeetmeokayimdead2222 cool!
yeetmeokayimdead2222 i am new here!
And taking a lot of time to work around