Database object details differ from the real database

Questions and answers regarding the use of eclipse environment as seen in Servoy Developer

Database object details differ from the real database

Postby Foobrother » Wed Jul 15, 2009 10:10 am

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!
Current configuration: Servoy 5.2.6 Build 1011, Java 6u24, PostgreSQL 8.3, Windows Server 2003

Servoy / Java Developer
http://www.assetguardian.com
User avatar
Foobrother
 
Posts: 530
Joined: Tue Jan 13, 2009 5:46 pm

Re: Database object details differ from the real database

Postby jcompagner » Wed Jul 15, 2009 10:51 am

can you quick fix them?
so select and then Quick Fix (ctrl-1)
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Database object details differ from the real database

Postby Foobrother » Wed Jul 15, 2009 11:14 am

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

Ohh I didn't saw this option!

Thx
Current configuration: Servoy 5.2.6 Build 1011, Java 6u24, PostgreSQL 8.3, Windows Server 2003

Servoy / Java Developer
http://www.assetguardian.com
User avatar
Foobrother
 
Posts: 530
Joined: Tue Jan 13, 2009 5:46 pm

Re: Database object details differ from the real database

Postby amcgilly » Fri Apr 09, 2010 1:08 am

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!
Adrian McGilly
Servoy Developer

Image
amcgilly
 
Posts: 375
Joined: Fri Dec 09, 2005 12:03 am
Location: San Francisco, CA


Return to Eclipse Environment

Who is online

Users browsing this forum: No registered users and 11 guests