Database object details differ from the real database

Classic Servoy
1

Hi everybody,

I did several changes in the database in the past and apparently Developer doesn’t update these details?!
I get almost 100 error like that:

Severity and Description Path Resource Location Creation Time Id
‘epic->tbl_epc_invoices->cal_goods_total’ column difference. (NUMBER(id:2), length: 19, allowNull: true) in DB ↔ (NUMBER(id:7), length: 4, allowNull: true) in DB information file. The DB information on this column differs from the actual column in the DB. servoy_AG-Dev_resources/datasources/epic tbl_epc_invoices.dbi JSON file 1247643997674 66517

I tried to “Synchronize with DB Server information” and “Reload tables/table structure from DB” but I still had these errors.
So I have simply deleted that data servers from developer and created them again. But I still have these errors!

2

can you quick fix them?
so select and then Quick Fix (ctrl-1)

3

jcompagner:
can you quick fix them?
so select and then Quick Fix (ctrl-1)

Ohh I didn’t saw this option!

Thx

4

This thread helped me out a lot.

I have been very impressed with the quality of the errors and warnings that show up in the Problems tab. Very clear, very detailed and even very good grammar!

Now I see that sometimes they even come with a ‘Quick Fix’ command that fixes the problem!

Nice work Servoy!