Home » RADICORE development » Framework » Issues with Radicore V 1.75
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Issues with Radicore V 1.75 [message #3132 is a reply to message #3123] |
Wed, 07 November 2012 10:33   |
juanguilarte
Messages: 27 Registered: June 2012
|
Junior Member |
|
|
I have some issue with float datatype when i try to update or insert table columns in the dictionary database.
T am using Radicore V 1.76 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
I attached the message
Thank you in advance
Juan Guilarte
Esta aplicacion ha encontrado un error inrrecuperable
Lo siguiente ha sido reportado al administrador:
2012-11-07 15:27:01
Error fatal: ORA-01426: desbordamiento numérico (# 1426).
SQL instruccion: UPDATE dict_column SET col_comment=NULL,col_type='float', col_type_native='float', col_array_type=NULL,col_values=NULL,user_size=22,col_maxsize =22,col_unsigned='N', col_zerofill_bwz=NULL,col_minvalue=-1.000000e+126,col_maxval ue=1.000000e+126,user_minvalue=-1.000000e+126,user_maxvalue= 1.000000e+126,noedit_nodisplay=NULL,no_search=NULL,no_audit= NULL,upper_lowercase=NULL,col_subtype=NULL,boolean_true=NULL ,boolean_false=NULL,control=NULL,optionlist=NULL,checkbox_la bel=NULL,task_id=NULL,foreign_field=NULL,align_hv=NULL,align _lr=NULL,custom_validation=NULL,revised_date='2012-11-07 15:27:01', revised_user='MGR' WHERE database_id='sistema_pagos' AND table_id='reg_mov_fac' AND column_id='num_tarj_ft'
Error en linea 1571 del archivo 'C:\wamp\www\radicore\includes\dml.oracle.php5.class.inc'.
Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Database: ORCL32, Schema: TREOMDP_DICT
PHP_SELF: /radicore/dict/column(add4)import.php
CURRENT DIRECTORY: C:\wamp\www\radicore\dict
SERVER_ADDR: 127.0.0.1
SERVER_NAME: localhost
HTTP_HOST: localhost
Codigo de Usuario: MGR
REMOTE_ADDR: 127.0.0.1
REQUEST_URI: /radicore/dict/column(add4)import.php?session_name=menu1
|
|
|
|
Re: Issues with Radicore V 1.75 [message #3135 is a reply to message #3133] |
Wed, 07 November 2012 21:40   |
juanguilarte
Messages: 27 Registered: June 2012
|
Junior Member |
|
|
Sure this is the create script:
CREATE TABLE "TREOMDP_SISTEMA_PAGOS"."REG_MOV_FAC"
( "EMPRESA_FT" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"BIN_TARJ_FT" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_TARJ_FT" FLOAT(126) DEFAULT '0' NOT NULL ENABLE,
"CONSE_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"COD_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_AUTO_MOV" CHAR(7 CHAR) DEFAULT '0' NOT NULL ENABLE,
"NRO_COMER_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_SUC_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"MONTO_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_MOV" CHAR(2 CHAR) DEFAULT 'BS' NOT NULL ENABLE,
"MONTO_EXT_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_EXT_MOV" VARCHAR2(2 CHAR) DEFAULT ' ' NOT NULL ENABLE,
"MONTO_INTER_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_INTER_MOV" VARCHAR2(2 CHAR) DEFAULT ' ' NOT NULL ENABLE,
"FECHA_PRO_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"NOMBRE_CON_MOV" CHAR(25 CHAR) NOT NULL ENABLE,
"FECHA_TRAN_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"CONT_COM_MOV" CHAR(1 CHAR) NOT NULL ENABLE,
"FECHA_DEP_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"CON_NRO_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NOM_PAIS_MOV" CHAR(8 CHAR) NOT NULL ENABLE,
"PROCED_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"TIPO_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"MARCA_AJU_MOV" CHAR(1 CHAR) NOT NULL ENABLE,
"NRO_REF_INC_MOV" CHAR(23 CHAR) NOT NULL ENABLE,
"CATEGORIA_COMER_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"FECHA_FT" CHAR(10 CHAR) DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
CONSTRAINT "PRIMARY_31" PRIMARY KEY ("BIN_TARJ_FT", "NUM_TARJ_FT", "FECHA_FT", "CONSE_MOV")
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Jul 05 18:39:44 EDT 2025
Total time taken to generate the page: 0.19966 seconds
|