Cannot Modify

[mantraxer21]

En este caso la llave primaria es "ID_DESPACHO". y están de la siguiente forma.

Select Sql:

Código SQL [-]
select FECHA_DES, ID_CAMION, ID_CHOFER, ID_COMUNA_DES, ID_DESPACHO, NUMERO_DESPACHO, TOTAL_DES from DESPACHO;

Modify Sql:

Código SQL [-]
update DESPACHO
set
  FECHA_DES = :FECHA_DES,
  ID_CAMION = :ID_CAMION,
  ID_CHOFER = :ID_CHOFER,
  ID_COMUNA_DES = :ID_COMUNA_DES,
  ID_DESPACHO = :ID_DESPACHO,
  NUMERO_DESPACHO = :NUMERO_DESPACHO,
  TOTAL_DES = :TOTAL_DES
where
  ID_DESPACHO = :OLD_ID_DESPACHO

Insert Sql

Código SQL [-]
insert into DESPACHO
  (FECHA_DES, ID_CAMION, ID_CHOFER, ID_COMUNA_DES, ID_DESPACHO, NUMERO_DESPACHO, 
   TOTAL_DES)
values
  (:FECHA_DES, :ID_CAMION, :ID_CHOFER, :ID_COMUNA_DES, :ID_DESPACHO, :NUMERO_DESPACHO, 
   :TOTAL_DES)

Delete Sql:

Código SQL [-]
delete from DESPACHO
where
  ID_DESPACHO = :OLD_ID_DESPACHO

Refresh Sql:

Código SQL [-]
Select 
  FECHA_DES,
  ID_CAMION,
  ID_CHOFER,
  ID_COMUNA_DES,
  ID_DESPACHO,
  NUMERO_DESPACHO,
  TOTAL_DES
from DESPACHO 
where
  ID_DESPACHO = :ID_DESPACHO