Board index » delphi » numeric field: invalid field type

Eduardo Xavier

Delphi Developer
Fri, 06 Jun 2003 06:20:31 GMT

numeric field: invalid field type

Hello.

I'm new to InterBase and I would create a simple table but D5 returns
"invalid field type".

The table is:
id char (3)
value numeric (10,2)

Thanks.

--
Eduardo Xavier

 
Team

Delphi Developer
Fri, 06 Jun 2003 08:40:15 GMT

Re:numeric field: invalid field type


Are you using the BDE and IB 6 with Dialect 3?  That sounds like your
combination since the BDE can not handle int64 and Numeric(10,2) maps to an
scaled Int64.  If you are using IBX make certain your SQLDialect for the
IBDatabase is dialect 3.

Quote
Eduardo Xavier wrote:

> Hello.

> I'm new to InterBase and I would create a simple table but D5 returns
> "invalid field type".

> The table is:
> id char (3)
> value numeric (10,2)

> Thanks.

> --
> Eduardo Xavier

--
Jeff Overcash (TeamB)   | Talk about failure
(Please do not email    | To fall is not to fail
 me directly unless     | Failure isn't about falling down
 asked.  Thank You)     | Failure is staying down (Marillion)

Other Threads

1. Help - Invalid Field Type - New Field Types?

2. numeric field type same as float type??

3. Invalid Field Type for nchar and nvarchar data types

4. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

5. ADO fields types and common field types?

6. Numeric field type prob in Delphi 4

7. Interbase Numeric and Decimal field types

8. dBase numeric field type issue

9. Batchmove from TQuery to TTable loses Numeric field typing

10. exact field size of numeric fields in DBF files