Changeset 258 for Network/CoolWeb/Persistence/USqlDatabase.pas

Timestamp:

Jul 26, 2011, 1:05:39 PM (13 years ago)

Author:

george

Message:

• Minor modifications

File:

• Network/CoolWeb/Persistence/USqlDatabase.pas (modified) (2 diffs)

Network/CoolWeb/Persistence/USqlDatabase.pas

@@ -312 +312 @@
     StringReplace(Value, '"', '\"', [rfReplaceAll]);
     if Value = 'NOW()' then DbValues := DbValues + ',' + Value
-    else DbValues := DbValues + ',' + Data.Keys[I] + '=' + '"' + Value + '"';
+    else DbValues := DbValues + ',`' + Data.Keys[I] + '` =' + '"' + Value + '"';
   end;
   System.Delete(DbValues, 1, 1);
@@ -318 +318 @@
     DbResult := TDbRows.Create;
     if Schema <> '' then Schema := '`' + Schema + '`.';
-    Query(DbResult, 'UPDATE ' + Schema + '`' + ATable + '` SET (' + DbValues + ') WHERE ' + Condition);
+    Query(DbResult, 'UPDATE ' + Schema + '`' + ATable + '` SET ' + DbValues + ' WHERE ' + Condition);
   finally
     DbResult.Free;