adonchev
Регистриран на: 28 Окт 2010 Мнения: 65
|
Пуснато на: Пон Сеп 03, 2012 8:16 pm Заглавие: Проблем след актуализация с версия 2012.08.30 |
|
|
Здравейте,
след актуализиране на програмата се опитах да въведа документ за покупка, но при приключване ми излиза следното съобщение:
"Line 18: Incorrect syntax near '0'.
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
Call stack:
[\\ANTON-DB1417367] DreemTrade15.frmSupDocuments.m_oForm_Save(3586)
[\\ANTON-DB1417367] DreemContainer15.cHost(Dreem15_Personal (Dreem), 1784).RemoteExec(1362)
[\\ANTON-DB1417367] DreemContainer15.cTransProxy(6.UpdSupDocsDetails, owner frmSupDocuments, 1933).BeginExec(972)
[\\ANTON-DB1417367] DreemTrans15.cAdm_Supplies.UpdSupDocsDetails(1108)
[\\ANTON-DB1417367] DreemTrans15.mdDAL.UpdateWithTempTableHelper(1916)
[\\ANTON-DB1417367] DreemTrans15.mdDAL.ExecCommandHelper(916)
UPDATE [v_sup_DocsInt]
SET [DocType_ID] = '{9B2D1D89-DA25-4EBA-A4C3-C235666BFEC6}'
, [DocNo] = '0092012143'
, [DocDate] = '20120822'
, [OperNo] = 'E82'
, [WayOfPayment] = 1
, [ownCg_ID] = '{AA479129-A354-4466-801B-4C8D595FB08C}'
, [ownPrsCreator_ID] = '{E6887FB3-7D8E-46E1-9C42-09AF986A7C87}'
, [ownPrsResp_ID] = '{0175CCC4-D733-40D8-9FB0-24652B172CE0}'
, [ownPrsMol_ID] = '{0175CCC4-D733-40D8-9FB0-24652B172CE0}'
, [Cg_ID] = '{CFF8A9FC-4014-476B-9328-6C4385DD0F92}'
, [CgAddress] = 'район Владислав Варненчик, БИЗНЕС ПАРК ВАРНА, СГРАДА 6 обл.ВАРНА ГР.ВАРНА 9009'
, [CgTaxNo] = 'BG103533691'
, [CgBulstat] = '103533691'
, [CgPrsMol_ID] = '{ECF6D95F-E113-415B-B51E-AAB6D91B72DF}'
, [CgPrsResp_ID] = '{ECF6D95F-E113-415B-B51E-AAB6D91B72DF}'
, [OwnPrsReceive_ID] = '{0175CCC4-D733-40D8-9FB0-24652B172CE0}'
, [TotalDiscount] = 0,0
, [TotalSum] = 28,39
, [TotalVat] = 5,68
, [IsVatIncluded] = 0
, [OwnCgDeliveryPlace] = ''
, [Note] = ''
, [State] = 1
, [CU] = 'Dreem'
, [CD] = '20120903 21:01:35'
, [LU] = 'Dreem'
, [LD] = '20120903 21:02:47'
, [SecurityLevel] = 0
, [PaymentDate] = '20120822'
, [ExecutionDate] = '20120822'
, [VatReason_ID] = '{2FE5AACC-B15D-4F9F-8B11-7184AA73BEED}'
, [VatRate] = 20,0
, [AccDate] = '20120822'
, [AdditionalVat] = 0,0
, [CurrencyTotalSum] = 34,07
, [Rate] = 1,0
, [Currency_ID] = '{0F607917-085C-4552-8F3F-E747F814E034}'
WHERE [ID] = '{D6C7AAE6-FE4B-4103-B577-737F65565533}'
IF @@ROWCOUNT = 0
INSERT [v_sup_DocsInt]([ID]
, [DocType_ID]
, [DocNo]
, [DocDate]
, [OperNo]
, [WayOfPayment]
, [ownCg_ID]
, [ownPrsCreator_ID]
, [ownPrsResp_ID]
, [ownPrsMol_ID]
, [ownDep_ID]
, [Cg_ID]
, [CgAddress]
, [CgTaxNo]
, [CgBulstat]
, [CgPrsMol_ID]
, [CgPrsResp_ID]
, [CgDep_ID]
, [OwnPrsReceive_ID]
, [TotalDiscount]
, [TotalSum]
, [TotalVat]
, [IsVatIncluded]
, [TransportCg_ID]
, [TransportPrs_ID]
, [OwnCgDeliveryPlace]
, [Note]
, [State]
, [CU]
, [CD]
, [LU]
, [LD]
, [SecurityLevel]
, [PaymentDate]
, [ExecutionDate]
, [VatReason_ID]
, [VatRate]
, [SupWop_ID]
, [SupWopDocDate]
, [AccDate]
, [CnDnType]
, [AdditionalVat]
, [CurrencyTotalSum]
, [Rate]
, [Currency_ID])
SELECT '{D6C7AAE6-FE4B-4103-B577-737F65565533}'
, '{9B2D1D89-DA25-4EBA-A4C3-C235666BFEC6}'
, '0092012143'
, '20120822'
, 'E82'
, 1
, '{AA479129-A354-4466-801B-4C8D595FB08C}'
, '{E6887FB3-7D8E-46E1-9C42-09AF986A7C87}'
, '{0175CCC4-D733-40D8-9FB0-24652B172CE0}'
, '{0175CCC4-D733-40D8-9FB0-24652B172CE0}'
, NULL
, '{CFF8A9FC-4014-476B-9328-6C4385DD0F92}'
, 'район Владислав Варненчик, БИЗНЕС ПАРК ВАРНА, СГРАДА 6 обл.ВАРНА ГР.ВАРНА 9009'
, 'BG103533691'
, '103533691'
, '{ECF6D95F-E113-415B-B51E-AAB6D91B72DF}'
, '{ECF6D95F-E113-415B-B51E-AAB6D91B72DF}'
, NULL
, '{0175CCC4-D733-40D8-9FB0-24652B172CE0}'
, 0,0
, 28,39
, 5,68
, 0
, NULL
, NULL
, ''
, ''
, 1
, 'Dreem'
, '20120903 21:01:35'
, 'Dreem'
, '20120903 21:02:47'
, 0
, '20120822'
, '20120822'
, '{2FE5AACC-B15D-4F9F-8B11-7184AA73BEED}'
, 20,0
, NULL
, NULL
, '20120822'
, NULL
, 0,0
, 34,07
, 1,0
, '{0F607917-085C-4552-8F3F-E747F814E034}'
0x80040E14".
Съответно документа не успявам да го приключа и да го запиша. |
|