From 6339df04b0fb8b65e3ad193ec26b4f7c29a5da84 Mon Sep 17 00:00:00 2001 From: Thomas Kasulke Date: Wed, 25 Apr 2007 11:53:02 +0000 Subject: [PATCH] =?utf8?q?SQL-Syntax=20gro=C3=9F=20geschrieben=20/=20lesba?= =?utf8?q?rer=20gemacht=20:=20update=20->=20UPDATE=20usw.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/IR.pm | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/SL/IR.pm b/SL/IR.pm index ec64dc50c..3982b267e 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -646,14 +646,14 @@ sub post_invoice { $dbh->do($query) || $form->dberror($query); if ($form->{storno}) { - $query = qq| update ap set paid=paid+amount where id=$form->{storno_id}|; + $query = qq| UPDATE ap SET paid = paid+amount WHERE id = $form->{storno_id}|; $dbh->do($query) || $form->dberror($query); - $query = qq| update ap set storno='$form->{storno}' where id=$form->{storno_id}|; + $query = qq| UPDATE ap SET storno = '$form->{storno}' WHERE id = $form->{storno_id}|; $dbh->do($query) || $form->dberror($query); - $query = qq§ update ap set intnotes='Rechnung storniert am $form->{invdate} ' || intnotes where id=$form->{storno_id}§; + $query = qq§ UPDATE ap SET intnotes = 'Rechnung storniert am $form->{invdate} ' || intnotes WHERE id = $form->{storno_id}§; $dbh->do($query) || $form->dberror($query); - $query = qq| update ap set paid=amount where id=$form->{id}|; + $query = qq| UPDATE ap SET paid = amount WHERE id = $form->{id}|; $dbh->do($query) || $form->dberror($query); } -- 2.20.1