How to prevent VP from adding (10) to integer when DB is Sqlite

General Questions/Discussions
1

If I have 2 tables with an INTEGER(10) primary key, and create a many to many table in between, the resulting table also has an 2 INTEGER(10) fields.
The problem is that when I generate the DDL for SQLITE, the 2 tables ends up with INTEGER, while the inbetween table ends up with integer(10).
I figured out that I had to leave the ID Generator to Native in order to get INTEGER, but this field is not available on the inbetween table.

2

Hi Benoitd,

Thank you for your post. I have forwarded your case to our team for further studies. When there is any news I will post here.

Best regards,
Jick Yeung

3

Hi Benoitd,

According the our record the support of length was one of our user requests. It is optional. To remove (10), please set length to 0.

Best regards,
Jick Yeung

4

If I have 2 tables with an INTEGER ?