View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000844 | Склад | General | public | 2015-07-20 10:58 | 2015-08-05 17:18 |
| Reporter | ruslan | Assigned To | barry | ||
| Priority | urgent | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Summary | 0000844: -Склад - Приход - Контекстное меню-Экспорт корректировки в xml Ошибка! | ||||
| Description | Произошла ошибка: Dynamic SQL Error SQL error code = -206 Column unknown K2.VERNORNAMEID At line 17, column 47 ----- SELECT G.ID, G.NAME, G.FULLNAME, G.CODE, Sum(K.SOURCE) QUANT, D.PRICE, D.NDS, K1.TGRPCODE CODUKTVED, G.CODUKTVED HBUKTVED, g.OneID, h.Name ONE, h.Code One_Code, Cast(Null as TimeStamp) GTDDATE, Cast(Null as varchar(32)) GTDNBR, Cast(Null as TimeStamp) SGTDDATE, Cast(Null as varchar(32)) SGTDNBR, K2.VendorNameID, v.Name VendorName FROM GddKt K LEFT JOIN GddDt D ON D.ID=K.GddKey LEFT JOIN GOODS G ON G.ID=K.GdsKey LEFT JOIN GddKt K1 on K1.ID=D.GddKey LEFT JOIN GddKt_SrcKtID(K.ID) S on 0=0 LEFT JOIN GddKt K2 on K2.ID=S.KTID LEFT JOIN VendorName V on V.ID=K2.VendorNameID LEFT JOIN HbOne h ON h.ID=g.OneID WHERE K.DgvKey=:ID Group By G.ID, G.Name, G.FullName, G.Code, K2.VernorNameID, V.Name, G.OneID, h.Name, h.Code, D.Price, D.Nds, K1.TGRPCODE , G.CODUKTVED ORDER BY G.NAME, G.FULLNAME, G.CODE Склад[ADMIN] Application.MainForm: FormStor(TFormStor) XE2 Склад: Эксперементальная (ТВИН-ДРУК АО ПП) [Р.В. Черних] ActiveForm: FormStor(TFormStor) XE2 Склад: Эксперементальная (ТВИН-ДРУК АО ПП) [Р.В. Черних] ActiveCustomForm: FormStor(TFormStor) XE2 Склад: Эксперементальная (ТВИН-ДРУК АО ПП) [Р.В. Черних] | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-07-20 10:58 | ruslan | New Issue | |
| 2015-07-20 11:03 | ruslan | Note Added: 0002056 | |
| 2015-07-24 09:45 | barry | Note Added: 0002065 | |
| 2015-07-24 09:45 | barry | Status | new => resolved |
| 2015-07-24 09:45 | barry | Resolution | open => fixed |
| 2015-07-24 09:45 | barry | Assigned To | => barry |
| 2015-08-05 17:18 | ruslan | Status | resolved => closed |
