INSERT sql changes

jimpoe

Member²
Using MIDAS, Delphi 5.1, and DOA 3.4.2
I have an OracleDataset linked to a provider. When I insert the first record I the sql generated is

insert into "QUOTE_CONTR"
("QUOTE_CONTR_ID", "QUOTE_ID", "MKT_CONTR_ID", "MKT_PROG_ID", "MKT_LINE_ID")
values
(:V0, :V1, :V2, :V3, :V4)

When I insert the second record, the sequel generated is

insert into "QUOTE_CONTR"
("QUOTE_ID", "MKT_CONTR_ID", "MKT_PROG_ID", "MKT_LINE_ID")
values
(:V0, :V1, :V2, :V3)

As you can see, "QUOTE_CONTR_ID" is missing. There's virtually no difference in the editing and posting of the two records.

Thanks for any help.
 
Back
Top