02-05-20, 12:41 AM
اشكرك ، ولكن المشكلة ما زالت قائمة ....
وعند تنفيذ القيم مباشرة في sql manager يقبل التنفيذ ..
INSERT INTO InvMaster
(StationNo, SOR, InvNo, InvDate, CustNo, UserId, Total, DiscMode, DiscPercent, Disc, NetTotal, CurNo, CurNoReturns, CurPrice, CurPriceReturns, Returnss, PayMethod, amtPaid, roundingOff, PointGroup, PointValue, PointItem, PointTotal, Notes, TrFlag, SyncBatch, NoCopy, PointMember, PointMemberDisc, MemBerDisc, InvholdNo, CustNoTERM, TERM, Disccamp,
DiscPercentcamp, Discinvoice, DiscPercentinvoice, SessionID)
VALUES (1, 1, 7975, ' 20200428', NULL, 1, 15, 0, 0, 15, 0, 0, 1, 1, 0, 1, 15, 0, 0, 0, 0, 0, 0, 1, 0, '20200428', 1, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0)
وشكرا لمروركم
وعند تنفيذ القيم مباشرة في sql manager يقبل التنفيذ ..
INSERT INTO InvMaster
(StationNo, SOR, InvNo, InvDate, CustNo, UserId, Total, DiscMode, DiscPercent, Disc, NetTotal, CurNo, CurNoReturns, CurPrice, CurPriceReturns, Returnss, PayMethod, amtPaid, roundingOff, PointGroup, PointValue, PointItem, PointTotal, Notes, TrFlag, SyncBatch, NoCopy, PointMember, PointMemberDisc, MemBerDisc, InvholdNo, CustNoTERM, TERM, Disccamp,
DiscPercentcamp, Discinvoice, DiscPercentinvoice, SessionID)
VALUES (1, 1, 7975, ' 20200428', NULL, 1, 15, 0, 0, 15, 0, 0, 1, 1, 0, 1, 15, 0, 0, 0, 0, 0, 0, 1, 0, '20200428', 1, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0)
وشكرا لمروركم
