Problem with unidac, Oracle and field defaults

ericalves · Post by **ericalves** » Fri 29 Oct 2010 13:57

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?

AlexP · Post by **AlexP** » Mon 01 Nov 2010 12:19

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.?

ericalves · Post by **ericalves** » Mon 01 Nov 2010 13:24

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.

AlexP · Post by **AlexP** » Tue 02 Nov 2010 12:25

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.