default insert syntax

[jimpoe]

I have the following table, MKT_PROG:
MKT_PROG_ID NUMBER (10) NOT NULL,
MKT_CONTR_ID NUMBER (10) NOT NULL,
PROG_ID NUMBER (10) NOT NULL,
ACTIVE CHAR (1) DEFAULT 'T' NOT NULL,
RANK NUMBER (6),
CONSTRAINT MKT_PROG_PK
PRIMARY KEY ( MKT_PROG_ID ) ) ;

My select is :
SELECT A.*, A.ROWID
FROM MKT_PROG A
WHERE A.MKT_CONTR_ID=:MKT_CONTR_ID
ORDER BY A.RANK

When I applyupdates, using MIDAS, I get the following insert syntax:

insert into "MKT_PROG"
( "MKT_CONTR_ID", "PROG_ID", "ACTIVE" )
values
( : V0, :V1, :V2 )

Why is MKT_PROG_ID included in this insert? I populate MKT_PROG_ID on the client.

Thanks
Jim

 

[Marco Kalter]

The SQL is generated by the TDataSetProvider. Is there anything special about the MKT_PROG_ID field? Is the FieldKind fkData?

------------------
Marco Kalter
Allround Automations