View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000967 | Database Comparer VCL | General | public | 2016-09-13 15:20 | 2018-04-10 15:13 |
| Reporter | shirokov | Assigned To | shirokov | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | won't fix | ||
| Summary | 0000967: Delphi 5 generates invalid script | ||||
| Description | Delphi 5 generates following script INSERT INTO ITEMTYPE1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, , , Null, Null, Null, -1, 0, 0, , 391, 4, Null, Null) GO INSERT INTO ITEMTYPE1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, , , Null, Null, Null, -1, 0, 0, , 391, 4, Null, Null) GO INSERT INTO ITEMTYPE1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, , , Null, Null, Null, -1, 0, 0, , 6, 4, Null, Null) GO INSERT INTO ITEMTYPE1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, , , Null, Null, Null, -1, 0, 0, , 0, 4, Null, Null) GO Delphi 7 generates following Script: INSERT INTO ItemType1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, '03', 'CIGARATTE & LIGHTERS', Null, Null, Null, -1, 0, 0, '03%s', 406, 4, Null, Null) GO INSERT INTO ItemType1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, '04', 'BEVERAGES', Null, Null, Null, -1, 0, 0, '04%s', 1719, 4, Null, Null) GO INSERT INTO ItemType1 (ItemGroup, ItemType, Description, GLIncomeExpAcc, GLCostAcc, GLInvtAcc, TranLevel, TotalQty, TotalAmt, ItemNumbFmt, ItemCount, SLNumbLength, CouponDiscPer, LeaseItem) VALUES(Null, '05', 'BOTTLE PROVISION', Null, Null, Null, -1, 0, 0, '05%s', 1416, 4, Null, Null) GO Kindly note that script generated from Delphi 5 is incorrect where as script from Delphi 7 is correct. Delphi5 does not give values for ItemType,Description where as Delphi7 Gives correct value. | ||||
| Additional Information | It seems, the problem is nVarchar datatype, which is not supported in DELPHI5 | ||||
| Tags | No tags attached. | ||||
