INSERT INTO POGGERS (id STRING PRIMARY KEY, tasktype TEXT, tasktitle TEXT, taskdescription TEXT, taskcompleted TEXT, datetime TEXT, datetimedue TEXT, taskpriority TEXT) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
i keep getting a "near "STRING": syntax error" any clues?
Oh, it’s an insert.
No specifying primary key there
that’s only in the create table
INSERT INTO POGGERS (id, tasktype, tasktitle, taskdescription, …)
insert into needs only column names, which will come from your create table.
doing all of this on https://sqliteonline.com
thank you for helping regardless @RandalSchwartz :)
and do you have the values for the ? placeholders?
when in doubt, read the doc.
ahh, it is
VALUES
If I have published Android and iOS apps, and I want to create a new screen using Flutter that both the Android and iOS apps incorporate. What's the best way to do this? I've read the flutter.dev instructions regarding creating a module. Even if I add a module to both Android and iOS projects, I'm still not sharing code between the projects yet. So this is what I believe I need to do:
- Add Android module.
- Add iOS module.
- Create a package that contains all code for the new screen.
- Add this new package as a dependency of the Android and iOS modules created in steps 1 and 2.
Does this look right? Have I missed something?
1 reply
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?
