Question: How can I create a `for` loop for this, in VB.Net? (shown below)

the code below adds values to my chart and is populated by labels that are stored on the windows form.

```
With .Points
    .AddXY(0, 0)
    .AddXY(1, LblWkEff1.Text)
    .AddXY(2, LblWkEff2.Text)
    .AddXY(3, LblWkEff3.Text)
    .AddXY(4, LblWkEff4.Text)
    .AddXY(5, LblWkEff5.Text)
    .AddXY(6, LblWkEff6.Text)
    .AddXY(7, LblWkEff7.Text)
    .AddXY(8, LblWkEff8.Text)
    .AddXY(9, LblWkEff9.Text)
    .AddXY(10, LblWkEff10.Text)
End With

```

Answer: 
So I landed here with an issue that my SQLite table wasn't auto-incrementing the primary key. I have a slightly complex use case where I want to use postgres in production but sqlite for testing to make life a bit easier when continuously deploying.

It turns out SQLite doesn't like columns defined as BigIntegers, and for incrementing to work they should be set as Integers. Remarkably SQLAlchemy can handle this scenario as follows using the with\_variant function. Thought this may be useful for someone:

```
id = db.Column(db.BigInteger().with_variant(db.Integer, "sqlite"), primary_key=True)

```

Further details here <https://docs.sqlalchemy.org/en/13/dialects/sqlite.html>
You cannot add "autoincrement" flag in column definition, moreover add "\_\_table\_\_args" attribute just after \_\_table\_\_name.
Something like this:

> 
> 
> ```
>     __tablename__ = 'table-name'
>     __table_args__ = {'sqlite_autoincrement': True} -> This adds autoincrement to your primary key.
> 
> ```
> 
> 

Try it, I hope this work for you ;) !