flutter/flutter

Flutter makes it easy and fast to build beautiful apps for mobile and beyond.

macphailmagwira

@macphailmagwira


  @override
  void initState() {
    super.initState();

 updatemail();

  }

 var secureRandom = SecureRandom();
    checkPreparing()    {

    var docSnapshot = FirebaseFirestore.instance
        .collection('bookings')
        .where('customer', isEqualTo: user_email22.toString());

    var docSnapshot2 =
        docSnapshot.where('status2', isEqualTo: 'preparing').snapshots();

    return docSnapshot2;
  }

i need to use the value in this query

Johannes Milke

@JohannesMilke_twitter

Hello! I have created another video about "DropdownButton - Single & Multiple Data - Flutter" https://www.youtube.com/watch?v=p1mzz6-19zo alt

Randal L. Schwartz

@RandalSchwartz

@JohannesMilke_twitter You should create a channel for that. When you get 100 subscribers, you can assign a meaningful name.

Randal L. Schwartz

@RandalSchwartz

Or at least a playlist.

murisjoh

@murisjoh

Hello! any suggestions and recommendations on which is better, visual studio code or Android studio for flutter and dart projects (that`s for mobile app development).

Randal L. Schwartz

@RandalSchwartz

is emacs or vim better?

@murisjoh ^^

Alexandra Deas

@alexandradeas_gitlab

@murisjoh whichever one you're used to

matrixbot

@matrixbot

linda234 Do you want to be financially stable? Have you started making money from home? Why not trade your way into good life. Trade binary option with the most reliable broker you can think of. Contact me @ +1 (414) 400-7564

Randal L. Schwartz

@RandalSchwartz

Reported to admins.

matrixbot

@matrixbot

darosa-fvs Was Bruder

Kyle

@kyle21z

anyone here understands in SQFlite?

i’ve got a syntax error, would really appreciate some help :)

Randal L. Schwartz

@RandalSchwartz

Might be able to spot it

Mua Rachmann

@muarachmann

Hi everyone... I have been on this for hours now till no avail and trying to search but yet no success. I have a listview builder that basically creates some. I have impleted a gesture detecture on each and I want it to pop a menu on long press. My menu shows but the position: RelativeRect.fromLTRB(100, 400, 100, 400) for example is fixed. Is there any way to make it show dynamically according to the position of the current element in the listview?. Basically I am hoping to change the property position such that the menu shows relatively to the selected listTile

Any help would be greatly appreciated thanks

Randal L. Schwartz

@RandalSchwartz

@kyle21z Can you paste it somewhere?

Kyle

@kyle21z

@RandalSchwartz ```

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?

Randal L. Schwartz

@RandalSchwartz

I think id is reserved.

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, …)

https://www.sqlite.org/lang_insert.html

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:

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

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.

Where communities thrive

People

Repo info

Activity