Changes between Version 23 and Version 24 of usefulQueries

Timestamp:

03/07/2020 02:21:51 AM (6 years ago)

Author:

sokol

Comment:

--

usefulQueries

@@ -249 +249 @@
 commit work;
 
-update t_configs set marker = 'Магазин' where config_id = 'kassa_labels_top' and config_id = 1;
-update t_configs set marker = '' where config_id = 'kassa_labels_top' and config_id > 1;
-update t_configs set marker = '' where config_id = 'leader' and config_id in (100, 101);
+update t_configs set marker = 'Магазин' where module = 'kassa_labels_top' and config_id = 1;
+update t_configs set marker = '' where module = 'kassa_labels_top' and config_id > 1;
+update t_configs set marker = '' where module = 'leader' and config_id in (100, 101);
 commit work;
 }}}
@@ -263 +263 @@
 begin
     for select n.nomen_id from t_nomens n
-              -- тут, за необхідності, може бути довыльна умова
+              -- тут, за необхідності, може бути довільна умова
             into tnomen_id
     do begin