'update. Help me, am I doing it wrong?

Here, is a code that updates the data in the fees column that corresponds to the Student ID entered by the student. There are no errors in the code, but the program doesn't seem to update the value in the database.

  Private Sub dbupdate()
        'Create a connection object.
        myConnectionString = "server=localhost;" _
              & "uid=root;" _
              & "pwd=password;" _
              & "database=dummystudents"

        Try
            'open the connection
            Dim conn As New MySql.Data.MySqlClient.MySqlConnection(myConnectionString)
            conn.Open()

            'create a command object.
            sql = "UPDATE students SET fees = '" & txtBalance.Text & "'WHERE idstudents = '" & txtStudentID.Text
            command = New MySqlCommand(sql, conn)
            command.ExecuteNonQuery()
            'Close connection
            conn.Close()

        Catch ex As Exception

        End Try


    End Sub
mysqlvb.netandroidiosflutter


Solution 1:[1]

I have the same issue on Android, with versions 3.0.0 and 2.4.0. So I tested downgrading back to 2.3.1, which is what we were using before, and explicitely selecting the hybrid composition mode, by adding:

    if (Platform.isAndroid) WebView.platform = SurfaceAndroidWebView();

in initState, as described in https://pub.dev/packages/webview_flutter/versions/2.3.1

The issue also occurs. So it's probably not specific to v3.0.0.

Another interesting observation: the issue remains present if we upgrade to 3.0.0, then downgrade back to 2.3.1 (removing the aforementioned code which explicitly activates hybrid composition), and cleanup the pub caches...

So it might be caused by a third-party dependency but I don't understand why cleaning up the dep cache doesn't fix the issue when reverting back from 3.0.0 to 2.3.1...

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Jim G

Related Questions