Can not update using TOraTable

Guillermo · Post by **Guillermo** » Wed 27 Feb 2008 05:07

Hi,

If I use TOraTable to access data and add all the fields available on the table using field editor (design time) when I try to modify a record I receive an error "Unknown data type" file oraclass.pas If you remove the fields definitions there is no problem. Using the debug option I noted that the update sentence didn't specify the param type for the key field.

This behavior is present in TUniTable also.

Guillermo.

Plash · Post by **Plash** » Wed 27 Feb 2008 08:59

Please provide a DDL for creating this table.
Specify whether you have changed some properties of TOraTable component, and exact ODAC version you are using.

Guillermo · Post by **Guillermo** » Wed 27 Feb 2008 17:33

Script creation:

CREATE TABLE PODERES (
ID NUMBER(9),
ESCRITURA VARCHAR2(50),
FECHA DATE,
LUGAR VARCHAR2(100),
NOTARIO NUMBER(9),
OBSERVACIONES CLOB,
VIGENCIA VARCHAR2(20),
FECHAINICIO DATE,
INSCRITO CHAR(1),
OBSERVACIONESINSCRIPCION CLOB,
OTORGANTE NUMBER(9),
UBICACION VARCHAR2(50),
ESTADO VARCHAR2(50),
PAIS VARCHAR2(50))
TABLESPACE USERS
STORAGE (
INITIAL 64K
MAXEXTENTS UNLIMITED
)
LOGGING;

Primary Key: ID

ODAC v 6.25.2.14

Plash · Post by **Plash** » Thu 28 Feb 2008 08:01

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create database objects.

Guillermo · Post by **Guillermo** » Mon 03 Mar 2008 21:21

Hi,

I was converting a SQL Server app to Oracle and KEY fields were of type AuntoInc and since I din't notice this I was getting this error. As soon as I change the type to Number, the message dissapear.

Guillermo.