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