https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=%D0%9E%D0%B1%D1%81%D1%83%D0%B6%D0%B4%D0%B5%D0%BD%D0%B8%D0%B5%3A%D0%9F%D0%B5%D1%80%D0%B5%D0%BD%D0%BE%D1%81_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85_%D0%BD%D0%B0_%D1%87%D0%B8%D1%81%D1%82%D1%83%D1%8E_%D0%B1%D0%B0%D0%B7%D1%83_%28%D0%BF%D0%BE%D1%81%D1%82%D0%B0%D0%BD%D0%BE%D0%B2%D0%BA%D0%B0%29 2026-07-17T07:44:43Z История изменений этой страницы в вики MediaWiki 1.19.16 https://gsbelarus.com:80/gs/wiki/index.php?title=%D0%9E%D0%B1%D1%81%D1%83%D0%B6%D0%B4%D0%B5%D0%BD%D0%B8%D0%B5:%D0%9F%D0%B5%D1%80%D0%B5%D0%BD%D0%BE%D1%81_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85_%D0%BD%D0%B0_%D1%87%D0%B8%D1%81%D1%82%D1%83%D1%8E_%D0%B1%D0%B0%D0%B7%D1%83_(%D0%BF%D0%BE%D1%81%D1%82%D0%B0%D0%BD%D0%BE%D0%B2%D0%BA%D0%B0)&diff=4806&oldid=prev 2011-09-12T14:15:41Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Предыдущая</td> <td colspan='2' style="background-color: white; color:black;">Версия 14:15, 12 сентября 2011</td> </tr><tr><td colspan="2" class="diff-lineno">Строка 1:</td> <td colspan="2" class="diff-lineno">Строка 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">Rод </del>добавления идентификаторов в множество, которые нужно перенести на чистую базу данных(для таблицы GD_DOCUMENT):</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">Код </ins>добавления идентификаторов в множество, которые нужно перенести на чистую базу данных(для таблицы GD_DOCUMENT):</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> </table>

Evgeny https://gsbelarus.com:80/gs/wiki/index.php?title=%D0%9E%D0%B1%D1%81%D1%83%D0%B6%D0%B4%D0%B5%D0%BD%D0%B8%D0%B5:%D0%9F%D0%B5%D1%80%D0%B5%D0%BD%D0%BE%D1%81_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85_%D0%BD%D0%B0_%D1%87%D0%B8%D1%81%D1%82%D1%83%D1%8E_%D0%B1%D0%B0%D0%B7%D1%83_(%D0%BF%D0%BE%D1%81%D1%82%D0%B0%D0%BD%D0%BE%D0%B2%D0%BA%D0%B0)&diff=4805&oldid=prev 2011-09-12T14:15:22Z

<p>Новая страница: «Rод добавления идентификаторов в множество, которые нужно перенести на чистую базу данных…»</p> <p><b>Новая страница</b></p><div>Rод добавления идентификаторов в множество, которые нужно перенести на чистую базу данных(для таблицы GD_DOCUMENT):<br /> <br /> <br /> EXECUTE BLOCK(Num integer = :num)<br /> AS<br /> DECLARE VARIABLE ID INTEGER;<br /> DECLARE VARIABLE PARENT INTEGER;<br /> DECLARE VARIABLE DOCUMENTTYPEKEY INTEGER;<br /> DECLARE VARIABLE TRTYPEKEY INTEGER;<br /> DECLARE VARIABLE TRANSACTIONKEY INTEGER;<br /> DECLARE VARIABLE NUMBER VARCHAR(20) CHARACTER SET WIN1251;<br /> DECLARE VARIABLE DOCUMENTDATE DATE;<br /> DECLARE VARIABLE DESCRIPTION VARCHAR(180) CHARACTER SET WIN1251;<br /> DECLARE VARIABLE SUMNCU NUMERIC(15,4);<br /> DECLARE VARIABLE SUMCURR NUMERIC(15,4);<br /> DECLARE VARIABLE SUMEQ NUMERIC(15,4);<br /> DECLARE VARIABLE DELAYED SMALLINT;<br /> DECLARE VARIABLE AFULL INTEGER;<br /> DECLARE VARIABLE ACHAG INTEGER;<br /> DECLARE VARIABLE AVIEW INTEGER;<br /> DECLARE VARIABLE CURRKEY INTEGER;<br /> DECLARE VARIABLE COMPANYKEY INTEGER;<br /> DECLARE VARIABLE CREATORKEY INTEGER;<br /> DECLARE VARIABLE CREATIONDATE TIMESTAMP;<br /> DECLARE VARIABLE EDITORKEY INTEGER;<br /> DECLARE VARIABLE EDITIONDATE TIMESTAMP;<br /> DECLARE VARIABLE PRINTDATE DATE;<br /> DECLARE VARIABLE DISABLED SMALLINT;<br /> DECLARE VARIABLE RESERVED INTEGER;<br /> DECLARE VARIABLE USR$EQRATE NUMERIC(15,4);<br /> DECLARE VARIABLE I INTEGER = 0;<br /> DECLARE VARIABLE J INTEGER = 1;<br /> BEGIN <br /> g_his_create(I);<br /> g_his_create(J);<br /> FOR<br /> SELECT ID,PARENT,DOCUMENTTYPEKEY,TRTYPEKEY,TRANSACTIONKEY,NUMBER,DOCUMENTDATE,DESCRIPTION,SUMNCU,<br /> SUMCURR,SUMEQ,DELAYED,AFULL,ACHAG,AVIEW,CURRKEY,COMPANYKEY,CREATORKEY,CREATIONDATE,<br /> EDITORKEY,EDITIONDATE,PRINTDATE,DISABLED,RESERVED,USR$EQRATE<br /> FROM GD_DOCUMENT<br /> INTO :ID,:PARENT,:DOCUMENTTYPEKEY,:TRTYPEKEY,:TRANSACTIONKEY,:NUMBER,:DOCUMENTDATE,:DESCRIPTION,<br /> :SUMNCU,:SUMCURR,:SUMEQ,:DELAYED,:AFULL,:ACHAG,:AVIEW,:CURRKEY,:COMPANYKEY,<br /> :CREATORKEY,:CREATIONDATE,:EDITORKEY,:EDITIONDATE,:PRINTDATE,:DISABLED,:RESERVED,:USR$EQRATE<br /> DO BEGIN<br /> g_his_include(J, :id);<br /> g_his_exclude(I, :id);<br /> if (g_his_has(J,:PARENT) = 0) then<br /> g_his_include(I, :PARENT);<br /> if (g_his_has(J,:DOCUMENTTYPEKEY) = 0) then<br /> g_his_include(I, :DOCUMENTTYPEKEY);<br /> if (g_his_has(J,:TRTYPEKEY) = 0) then<br /> g_his_include(I, :TRTYPEKEY);<br /> if (g_his_has(J,:TRANSACTIONKEY) = 0) then<br /> g_his_include(I, :TRANSACTIONKEY);<br /> if (g_his_has(J,:CURRKEY) = 0) then<br /> g_his_include(I, :CURRKEY);<br /> if (g_his_has(J,:COMPANYKEY) = 0) then<br /> g_his_include(I, :COMPANYKEY);<br /> if (g_his_has(J,:CREATORKEY) = 0) then<br /> g_his_include(I, :CREATORKEY);<br /> if (g_his_has(J,:EDITORKEY) = 0) then<br /> g_his_include(I, :EDITORKEY);<br /> END<br /> FOR<br /> SELECT ID,PARENT,DOCUMENTTYPEKEY,TRTYPEKEY,TRANSACTIONKEY,NUMBER,DOCUMENTDATE,DESCRIPTION,SUMNCU,<br /> SUMCURR,SUMEQ,DELAYED,AFULL,ACHAG,AVIEW,CURRKEY,COMPANYKEY,CREATORKEY,CREATIONDATE,EDITORKEY,<br /> EDITIONDATE,PRINTDATE,DISABLED,RESERVED,USR$EQRATE<br /> FROM GD_DOCUMENT<br /> INTO :ID,:PARENT,:DOCUMENTTYPEKEY,:TRTYPEKEY,:TRANSACTIONKEY,:NUMBER,:DOCUMENTDATE,:DESCRIPTION,<br /> :SUMNCU,:SUMCURR,:SUMEQ,:DELAYED,:AFULL,:ACHAG,:AVIEW,:CURRKEY,:COMPANYKEY,:CREATORKEY,<br /> :CREATIONDATE,:EDITORKEY,:EDITIONDATE,:PRINTDATE,:DISABLED,:RESERVED,:USR$EQRATE<br /> DO BEGIN<br /> if (g_his_has(J, :parent) = 1) then<br /> begin<br /> g_his_include(J, :id);<br /> g_his_exclude(I, :id);<br /> if (g_his_has(J,:PARENT) = 0) then<br /> g_his_include(I, :PARENT);<br /> if (g_his_has(J,:DOCUMENTTYPEKEY) = 0) then<br /> g_his_include(I, :DOCUMENTTYPEKEY);<br /> if (g_his_has(J,:TRTYPEKEY) = 0) then<br /> g_his_include(I, :TRTYPEKEY);<br /> if (g_his_has(J,:TRANSACTIONKEY) = 0) then<br /> g_his_include(I, :TRANSACTIONKEY);<br /> if (g_his_has(J,:CURRKEY) = 0) then<br /> g_his_include(I, :CURRKEY);<br /> if (g_his_has(J,:COMPANYKEY) = 0) then<br /> g_his_include(I, :COMPANYKEY);<br /> if (g_his_has(J,:CREATORKEY) = 0) then<br /> g_his_include(I, :CREATORKEY);<br /> if (g_his_has(J,:EDITORKEY) = 0) then<br /> g_his_include(I, :EDITORKEY);<br /> END<br /> END<br /> END</div>

Evgeny