Master/Slave Tables in Delphi 7 using MSAccess DBs result in "not a valid timestamp" error/exception
Posted on 2004-08-18
I have converted a Delphi 5 program to Delphi 7 which uses two MS Access tables, a master and a slave. Each has a datetime field in the primary key, which correspond.
When I to a TTable.Insert on Table 1 (master), I get an exception "0.0 is not a valid timestamp". The error occurs because Table 2 (slave) uses the datetime field in its master/slave key specifications. I know this because if I unlink the two tables and do an insert on each of them, I get no error.
TblTrustReq1CHKRequesterID.Value := 'KG';
TblTrustReq1CHKRequesterDate.Value := Now;
TblTrustReq1CHKCheckDate.Value := Now;
TblTrustReq2CHKRequesterID2.Value := TblTrustReq1CHKRequesterID.Value;
TblTrustReq2CHKDate.Value := TblTrustReq1CHKRequesterDate.Value;
TblTrustReq2CHKSequence.Value := 1;
Can anyone help?