Devart Forums

Hi,

I created a table in the database, then added two fields: Field1 Number (3) default 0 not null and field2 Number (3).
When adding the fields in the query was as field1 and field2 FloatField as smallint, and are equal. After I changed the field2 to not null and default value 0, being equal to field1, yet there was a difference in the query.

I use Delphi 7. Oracle 11.2.0.1.0. UniDAC 3.00.0.6.

What is the explanation for the problem?

Hello,

Please tell me more information about the problem.
What do you mean by 'equal' and 'difference' fields in a query, what are you comparing: data in fields, field types, etc.?

hi,

I mean the kind of field. The fields are the same type, but adding the field in the query (add fields), the types are different.
The difference between the two is how they were created.

Hello,

Please look at the following topic at our forum:
http://www.devart.com/forums/viewtopic.php?t=17432.
If you have the same situation you should create a table with all correct fields at once.