i am using this code to enter records:
$tr = ibase_trans(IBASE_COMMITTED + IBASENOWAIT);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',1,'$accounts')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',2, '$coredata')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',3, '$fes')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',4, '$reports')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',5, '$ledgers')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',6, '$bankrec')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',7, '$interestcalc')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',8, '$lamonitor')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',9, '$userguide')";
$result=ibase_query($sql);
$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('$lastclientid',10, '$yearend')";
$result=ibase_query($sql); ***********
if ($result=ibase_query($sql)) {
echo "The record has been entered successfully. <a href='displaydata.php'>Click here</a> to return to the main database page.";
ibase_commit($tr);
}
else die (ibase_errmsg());
}
?>
the records are being inserted to the database successfully! but i am given a primary foreign key constraint error message even though it has worked. 2 questions:
a. is my code above for entering multiple records efficient?
b. any ideas why im getting a foreign key violation? is it something i am doing wrong? n.b the error message is referring to the line i have marked ********
many thanks.
