Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
Kyle
@kyle21z
not quite sure what you mean by that @RandalSchwartz. I've tried changing "id" to something else yet I got the same error; I've thought its something with my code at first but I found out its an SQL error due to online syntaxes recognising the same error.
Randal L. Schwartz
@RandalSchwartz
gimme sec. googling. :)
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.
Kyle
@kyle21z
its a different error now, it's telling me that there's no such table.
doing all of this on https://sqliteonline.com
thank you for helping regardless @RandalSchwartz :)
Randal L. Schwartz
@RandalSchwartz
do you have “create table poggers (and your oother code you tried too insert)"
and do you have the values for the ? placeholders?
Kyle
@kyle21z
in the actual code yes, in the sqliteonline example, no
Randal L. Schwartz
@RandalSchwartz
well, that’s why it’s nott woorking then. :)
Kyle
@kyle21z
so change the questionmarks to values?
Randal L. Schwartz
@RandalSchwartz
No, for an insert, you’d use value(1, 3, 5, …)
when in doubt, read the doc.
ahh, it is VALUES
Spencer Riddering
@SpencerRiddering

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:

  1. Add Android module.
  2. Add iOS module.
  3. Create a package that contains all code for the new screen.
  4. 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
Kyle
@kyle21z
@RandalSchwartz would you mind including an example, I couldn't really understand. I believe the SQL code itself doesn't work yet I can't seem to understand why
Randal L. Schwartz
@RandalSchwartz
show me these two things: the entire “create table” statement, and the entire “insert into” statement.
Kyle
@kyle21z
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;
  }
Randal L. Schwartz
@RandalSchwartz
yeah, wrong syntax for insert
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 ( … )"
Kyle
@kyle21z
ill try hang on
Johannes Milke
@JohannesMilke_twitter
Hello! I have created another video about "WillPopScope & BackButton - Navigate Back Android - Flutter" https://www.youtube.com/watch?v=do5Ppu7Nfpg alt
Randal L. Schwartz
@RandalSchwartz
ooh, I don’t know the parameters for rawInsert
my advice is based on just sqlite.
Kyle
@kyle21z
@RandalSchwartz what a hero!
thank you c:
rawinsert is inserting the data into the database right?
Randal L. Schwartz
@RandalSchwartz
I don’t know. I know sqlite but not sqflite yet.
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
Ghost
@ghost~5f8f66f2d73408ce4ff20dd5
whats the best way to wait for an async function in a synchronous function?
Randal L. Schwartz
@RandalSchwartz
You can’t.
If any method is marked async, or uses the explicit Future/Stream protocol, everything that invokes it (and recursively) must also be non-blocking.
Randal L. Schwartz
@RandalSchwartz
More simply, if it returns a Future<…> or a Stream<…>, it and everything that invokes it must be treated as returning a Future or Stream.
matrixbot
@matrixbot
yeetmeokayimdead2222 hi
yeetmeokayimdead2222 what is future/stream?
matrixbot
@matrixbot
yeetmeokayimdead2222 thank u
Randal L. Schwartz
@RandalSchwartz
You’re welcome!
matrixbot
@matrixbot
yeetmeokayimdead2222 so, what is this group about!?
Randal L. Schwartz
@RandalSchwartz
Are you trolling now? Why would you ask about future/stream without some idea of the channel?