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.
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

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

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.