È íà äóøå êàê-òî ñòàëî ëåã÷å ñðàçó...

Íà÷àëîñü âñ¸ â÷åðà ñ òîãî, ÷òî ýëåìåíòàðíûé çàïðîñ â íåèìåíîâàíîì áëîêå, ïðèâÿçàíîì ê ñîçäàíèþ ôàêòóðû èç íàêëàäíîé (áëîê èñïðàâëÿë äàòó ôàêòóð&ucirc íà÷àë äåëàòü FULL SCAN TABLE, FULL SCAN INDEX, ãèãàáàéòíûé SORT....

Код:

select NOUT_DOCUMENT into nFAKT_RN from V_DOCLINKS_INOUT_OUT where NDOCUMENT = nNAKL_RN and SUNITCODE = 'GoodsTransInvoicesToConsumers' and SOUT_UNITCODE = 'AccountFactOutput';

&Igrave;&oacute;&divide;&agrave;&euml;&egrave;&ntilde;&uuml; &acirc;&aring;&ntilde;&uuml; &auml;&aring;&iacute;&uuml;, &iacute;&icirc; &eth;&agrave;&aacute;&icirc;&ograve;&agrave;&euml;&icirc; (&ntilde; &ccedil;&agrave;&auml;&aring;&eth;&aelig;&ecirc;&icirc;&eacute; &icirc;&ograve; 5 &auml;&icirc; 10 &igrave;&egrave;&iacute;&oacute;&ograve; &iacute;&agrave; &icirc;&auml;&iacute;&icirc; &ntilde;&icirc;&ccedil;&auml;&agrave;&iacute;&egrave;&aring; &ocirc;&agrave;&ecirc;&ograve;&oacute;&eth;&ucirc &Iuml;&icirc;&oacute;&aacute;&egrave;&eth;&agrave;&euml; &otilde;&egrave;&iacute;&ograve;&ucirc; &egrave;&ccedil; V_DOCLINKS_INOUT_OUT, V_DOCLINKS_INOUT_IN, V_PAYACC, V_DICACCFO, V_TRANSINVCUST &egrave; &ograve;.&auml;. &ntilde;&ograve;&agrave;&euml;&icirc; &quot;&oslash;&oacute;&eth;&oslash;&agrave;&ograve;&uuml;&quot; &ccedil;&agrave; &auml;&icirc;&euml;&egrave; &ntilde;&aring;&ecirc;&oacute;&iacute;&auml;&ucirc;. &iacute;&oacute; &yuml; &egrave; &iuml;&icirc;&atilde;&eth;&icirc;&otilde;&agrave;&euml; &acirc;&ntilde;&aring; &otilde;&egrave;&iacute;&ograve;&ucirc; &acirc;&icirc; &acirc;&ntilde;&aring;&otilde; &acirc;&uuml;&thorn;&otilde;&agrave;&otilde;. &igrave;&icirc;&aelig;&aring;&ograve; &atilde;&auml;&aring;-&ograve;&icirc; &egrave; &iacute;&aring; &ntilde;&icirc;&acirc;&ntilde;&aring;&igrave; &iuml;&eth;&agrave;&acirc;&egrave;&euml;&uuml;&iacute;&icirc;, &iacute;&icirc; &ograve;&agrave;&ecirc;&egrave;&otilde; &ntilde;&ograve;&eth;&agrave;&oslash;&iacute;&ucirc;&otilde; &atilde;&euml;&thorn;&ecirc;&icirc;&acirc; &ograve;&icirc;&divide;&iacute;&icirc; &iacute;&aring; &aacute;&oacute;&auml;&aring;&ograve;. &Egrave; &ecirc;&ograve;&icirc; &iuml;&eth;&egrave;&auml;&oacute;&igrave;&agrave;&euml; &acirc;&ntilde;&ograve;&agrave;&acirc;&euml;&yuml;&ograve;&uuml; &acirc;&aring;&ccedil;&auml;&aring; &yacute;&ograve;&icirc; /*+RULE*/ ????? <br><br>Сообщение отредактировано: Alexander, в: 2004/12/21 12:54