do_query($form, $dbh, $query, $form->{"id"}, $form->{"accno"});
}
- my @values;
+ @values = ();
if ($form->{id}) {
taxkey,
taxdescription,
round(rate * 100, 2) AS rate,
- chart_id
+ chart_id,
+ (id IN (SELECT tax_id
+ FROM acc_trans)) AS tax_already_used
FROM tax
WHERE id = ? |;