question

The following code gets the last row from the specified database table and adds it to the defined target table. You will have to adjust the connection name, the table names and, depending on the database you are reading from, the row identifier that is used select the last row ("ID" in this case).

Database.Connection con = Database.Connection("DBConnector1");
con.connect();
if(con.isConnected)
{
    // Get last row from database table
    Database.ResultSet result = con.query("SELECT * FROM Table1 WHERE ID = (SELECT MAX(ID) FROM Table1)");

    // Check if number of fields matches table columns and the result is not empty
    int entries = result.numFields;
    Table target = Table("GlobalTable1");
    if(result.fetchNext() && entries == target.numCols)
    {
        // Add new row and write values to it
        target.addRow();
        int row = target.numRows;
        for(int i = 1; i <= entries; i++)
        {
            target[row][i] = result[i];
        }
    }
}

You can loop a token through a Custom Code activity with this code every second.