Program Design

Member Avatar
Member Avatar
+0 forum 1

Good day, I am having trouble with the computation in SQL. i want to subtract the intStock and the intTotal_OutBound_items to just to get the items available. here is my SP.. INSERT INTO CO09_Report ( intMaterial ,txtDescription ,txtMaterial_Type ,txtATP_check ,intDelivering_Plant ,intOrder_Quantity ,isHeld_by_Finance ,isRejected_OOS ,isRejected_Others ,intOpen_Order_Quantity ,intOrder_Quantity_NKA ,intOrder_Quantity_RKA ,intOrder_Quantity_Others ,intStock ,intDSD_Delivery ,intOUtBound_Haulage ,intTotal_OutBound_items ,intInBound_Haulage ,intHaulage_In_Transit ,intProcess_Order ,intTotal_Inbound_Items ,(intStock) ) SELECT NODE.value('@Material','[BigInt]') ,NODE.value('@Description','[nvarchar](50)') ,NODE.value('@Material_Type','[nchar](10)') ,NODE.value('@ATP_check','[nchar](10)') ,NODE.value('@Delivering_Plant','[nchar](10)') ,NODE.value('@Order_Quantity','[int]') ,NODE.value('@Held_by_Finance','[bit]') ,NODE.value('@Rejected_OOS','[bit]') ,NODE.value('@Rejected_Others','[bit]') ,NODE.value('@Open_Order_Quantity','[int]') ,NODE.value('@Order_Quantity_NKA','[int]') ,NODE.value('@Order_Quantity_RKA','[int]') ,NODE.value('@Order_Quantity_Others','[int]') ,NODE.value('@Stock','[int]') ,NODE.value('@DSD_Delivery','[int]') ,NODE.value('@OutBound_Haulage','[int]') ,NODE.value('@Total_OutBound_items','[int]') ,NODE.value('@InBound_Haulage','[int]') ,NODE.value('@Haulage_In_Transit','[int]') ,NODE.value('@Process_Order','[int]') ,NODE.value('@Total_Inbound_Items','[int]') ,NODE.value('@intCustom_ATP_Quantity','[int]') FROM @xmlC009Report.nodes('dsExcelC009ReportRecords/dtExcelC009ReportRecords') TEMPXML(NODE) i need help, can someone help me with this prob.. thanks

Member Avatar
Member Avatar
+0 forum 2

Please Help me with this Date Operation Program. I think that this works....yet! Thanks #include <iostream.h> #include <conio.h> int a[7]={1,3,5,7,8,10,12}; int b[7]={4,6,9,11}; class manipdate { int date; int month; int year; public: int d,m,y; void getdata() { cout<<"\n\n Date : "; cin>>date; cout<<"\n Month : "; cin>>month; cout<<"\n Year : "; cin>>year; } void display(int d, int m, int y) { cout<<" "<<d<<" / "<<m<<" / "<<y; } manipdate sub(manipdate q) { if(q.d < 0) { q.d = -q.d; if(q.d>30) { for(int i=0;i<7;i++) { if(q.m==a[i]) { if(q.d>31) { q.d -= 31; q.m--; } } else if(q.m==b[i]) { q.d -= 30; …

Member Avatar
Member Avatar
+0 forum 5

pls help.. I have a to create a timecard calculator. it goes this way txtbox1 is for their 1st in txtbox2 is for their 1st out textbox3 is for the difference of txtbox1 and textbox2 txtbox4 is for their 2st in txtbox5 is for their 2st out textbox6 is for the difference of txtbox4 and textbox5 textbox7 is for the sum of total hour and minutes of textbox3 and textbox6

Member Avatar
Member Avatar
+0 forum 5

Hello, i am trying to figure out what i did wrong. i am trying to add a subtraction flag to my current 32 bit adder, and i keep getting the incorrect output back. For example, if the user enters: input 32 bits: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 input 32 bits: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 …

Member Avatar
Member Avatar
+0 forum 1

Hello programmers out there :) Im currently having problems with allowing the "-" in my TextBox. [B](Im using Visual Studio 2010)[/B] Im kinda new to programming, thats why this code looks messy. [CODE]void Form1::textBox9_KeyPress(System::Object^ sender, System::Windows::Forms::KeyPressEventArgs^ e) { if(!Char::IsDigit(e->KeyChar) && (e->KeyChar != 0x08) && (e->KeyChar != 0x6D)) e->Handled = true; }[/CODE] I tryed that, but this simply doesn't work, it doesn't allows anything. Thanks for future help :) (Sorry for my bad english, its not my motherlanguage)

Member Avatar
Member Avatar
+0 forum 4

so i know how to add the numbers in a list recursively [CODE] def ListSum(list): if list = []: return 0 else: return list[0] + ListSum(list[1:]) [/CODE] but how would i go about subtracting a list from a list using recursion? does anyone know how/ where i could go to learn how to do so thanks in advance

Member Avatar
Member Avatar
+0 forum 6

The End.