Revision 90221504
Von Moritz Bunkus vor mehr als 13 Jahren hinzugefügt
| SL/AM.pm | ||
|---|---|---|
| 378 | 378 |
|
| 379 | 379 |
} |
| 380 | 380 |
|
| 381 |
# Update chart.taxkey_id to the latest from taxkeys for this chart. |
|
| 382 |
$query = <<SQL; |
|
| 383 |
UPDATE chart |
|
| 384 |
SET taxkey_id = ( |
|
| 385 |
SELECT taxkey_id |
|
| 386 |
FROM taxkeys |
|
| 387 |
WHERE taxkeys.chart_id = chart.id |
|
| 388 |
ORDER BY startdate DESC |
|
| 389 |
LIMIT 1 |
|
| 390 |
) |
|
| 391 |
WHERE id = ? |
|
| 392 |
SQL |
|
| 393 |
|
|
| 394 |
do_query($form, $dbh, $query, $form->{id});
|
|
| 395 |
|
|
| 381 | 396 |
# commit |
| 382 | 397 |
my $rc = $dbh->commit; |
| 383 | 398 |
$dbh->disconnect; |
Auch abrufbar als: Unified diff
Beim Speichern eines Kontos chart.taxkey_id aus taxkeys aktualisieren/setzen
Fix für Bug 1627.