Column differs from actual column

Questions and answers regarding general SQL and backend databases

Column differs from actual column

Postby gdurniak » Sun Mar 03, 2013 2:34 pm

I connect to integers in a few FileMaker 11 tables, and get this odd error for Type: Numbers:

"filemaker->clients->active" column difference. (NUMBER(id:8), length: -1, scale: -1, allowNull: true) in DB <-> (NUMBER(id:8), length: -1, allowNull: true) in DB information file ... The DB information on this column differs from the actual column in the DB clients.dbi /resources/datasources/filemaker JSON file Database information inconsistency

The Quick Fix offers to "Accept column differences, and no longer report"

is that a proper solution ?

I tried Reloading the tables in Developer, but no difference

greg
Last edited by gdurniak on Tue Mar 12, 2013 5:02 am, edited 1 time in total.
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Column differs from actual column

Postby rgansevles » Tue Mar 05, 2013 2:23 pm

Greg,

The quickfix filters the column difference from the problems view.
It has no other consequences.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Column differs from actual column

Postby gdurniak » Tue Mar 12, 2013 5:06 am

I have already set my filters and preferences to hide many warnings that I know are insignificant

but is THIS warning insignificant ? I have no way to know, so I'm hesitant to hide it

greg

> The quickfix filters the column difference from the problems view ... It has no other consequences.
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Column differs from actual column

Postby rgansevles » Tue Mar 12, 2013 9:22 am

Greg,

The quickfix to accept this difference is not a general-accept-for-all-columns change, but only for this specific column.
So if you accept this one, Servoy will stop complaining about the column difference for this column, but not for columns with a similar difference.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 10 guests