B4R Question ESP8266 connect to mySQL and copy to global variable

Sub Process_Globals
    Private Output() As Byte
End Sub


Sub SQL_Select
   
    RunNative("Select", Null)                                                 
    Dim bc As ByteConverter
    Dim str As String = Output
    Log("Output Länge: ", Output.Length)
    Log("Output         : ", Output)
    Log("Output         : ", str)
'    Log("Output 0: ", bc.StringFromBytes(Output))
    Log("Output 0: ", Output(0))
    Log("Output 1: ", Output(1))
    Log("Output 2: ", Output(2))
    Log("Output 3: ", Output(3))
    Log("Output 4: ", Output(4))
    Log("Output 5: ", Output(5))
    Log("Output 6: ", Output(6))
    Log("Output 7: ", Output(7))
    Log("Output 8: ", Output(8))
    Log("Output 9: ", Output(9))
    Log("Output 10: ", Output(10))
End Sub

#if C
    #include <MySQL_Connection.h>
    #include <MySQL_Cursor.h>

    //MarieDB Settings
    IPAddress server_addr(192, 168, 0, 150); // IP of the MySQL *server* here
    char user[] = "myUser";              // MySQL user login username
    char password[] = "myPassword";        // MySQL user login password

    WiFiClient client;
    MySQL_Connection conn((Client *)&client);
    // Create an instance of the cursor passing in the connection
    MySQL_Cursor cur = MySQL_Cursor(&conn);


    void Select(B4R::Object* o) {
        char querySelect[] = "SELECT id, gain, gain_start, gain_faktor, intervall, wert, akku, rssi FROM haussteuerung_db.Sensoren_Wetter WHERE id = %d";
        char query[128];

        delay(1000);
        Serial.println("Connecting MariaDB...");
        if (conn.connect(server_addr, 3306, user, password)) {
        delay(1000);
        }
        else
        Serial.println("Connection failed.");
        delay(1000);

        //Create new Cursor
        MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
       
        // Execute the query
        sprintf(query, querySelect, 1);
        cur_mem->execute(query);

        // Fetch the columns and print them
        column_names *cols = cur_mem->get_columns();
        for (int f = 0; f < cols->num_fields; f++) {
            Serial.print(cols->fields[f]->name);
            if (f < cols->num_fields-1) {
                  Serial.print(',');
            }
        }
        Serial.println();
       
        //Read the rows and print them
        row_values *row = NULL;
        char* output[100];
        do {
            row = cur_mem->get_next_row();
            if (row != NULL) {
                for (int f = 0; f < cols->num_fields; f++) {
                    Serial.print(row->values[f]);
                    output[f] = row->values[f];
                    if (f < cols->num_fields-1) {
                        Serial.print(',');
                    }
                }
                Serial.println();
            }
        } while (row != NULL);

        // Copy the result
        b4r_mariadb::_output->data = output;
        b4r_mariadb::_output->length = sizeof(output);

        //Deleting the cursor also frees up memory used
        delete cur_mem;
    }

#End If

Public SQL_SensorTemperatur() As Double = Array As Double(0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00)                        'Wetter Sensor draussen