Oracle Output Result Copy and paste in Excel

Run the query after that :-  

1. Ctrl + A
2. Ctrl + Shift + C 
3. Paste to Excel

maintain scroll position javascript

http://stackoverflow.com/questions/17642872/refresh-page-and-keep-scroll-position

http://www.redips.net/javascript/maintain-scroll-position/?param1=a&param2=b&param3=c&scroll=606

Gridview update code behind c#

protected void TaskGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
  {    
    //Retrieve the table from the session object.
    DataTable dt = (DataTable)Session["TaskTable"];

    //Update the values.
    GridViewRow row = TaskGridView.Rows[e.RowIndex];
    dt.Rows[row.DataItemIndex]["Id"] = ((TextBox)(row.Cells[1].Controls[0])).Text;
    dt.Rows[row.DataItemIndex]["Description"] = ((TextBox)(row.Cells[2].Controls[0])).Text;
    dt.Rows[row.DataItemIndex]["IsComplete"] = ((CheckBox)(row.Cells[3].Controls[0])).Checked;

    //Reset the edit index.
    TaskGridView.EditIndex = -1;

    //Bind data to the GridView control.
    BindData();
  }

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowupdating(v=vs.110).aspx

Read/Display variable in XSLT asp .net

 

                             
                                RadioMemberadd:
                             

Update table with Join PL SQL

MERGE INTO  TBL500_BUSUPACCESS A
     USING (SELECT MCMCU,MCRP06, MCDL01 FROM CRPDTA.F0006@HIJDED1) B
        ON (A.BU = Ltrim(MCMCU))
WHEN MATCHED
THEN
   UPDATE SET
      A.BU_DESC =
         (CASE
             WHEN A.MCCO IN 1  THEN SUBSTR(A.MCCO,-2)||' (PAR) '|| MCDL01
             ELSE SUBSTR(A.MCCO,-2)||' ('||MCRP06||') '|| MCDL01 END);
End  SP_500_SUP_REPORTASSIGN ;

SP_Help in PLSQL

Select * from user_constraints where table_name='TBL500_BUSUPACCESS';

Oracle SQL Convert systemdate to JD Edwards Julian

select
to_number(concat('1',to_char(sysdate,'YYDDD')))
from dual ;

Get data from SQL Server and paste in a Activesheet VBA

SQL_Set_Connection

'Debug.Print SQL_Str
Set rst = cnt.Execute("budget.dbo.SP_PIP_Excel") '''' '" & CoFilter & "' ,'*','" & cbo_LT & "'")

If rst.RecordCount = 0 Then
  MsgBox "No Data available - contact Administrator"
  'GoTo Finish
End If



Dim RptName As String
Dim RptShtName As String

RptName = "\\dc01cxbudpv01\budget_software\MCE_Report1.xlsx"
RptShtName = "Sheet1"

Dim objXL
Set objXL = CreateObject("Excel.Application")

'AppActivate objXL
Workbooks.Open (RptName)

Workbooks("MCE_Report1.xlsx").Activate
ActiveWorkbook.Sheets("Sheet1").Activate
Debug.Print ActiveWorkbook.Name
Debug.Print ActiveSheet.Name
'objXL.Calculation = xlCalculationAutomatic
'Set WB = objXL.ActiveWorkbook

'On Error Resume Next
'WB.Sheets("Results").Range("Data1").EntireRow.Delete
'WB.Sheets("Results").Range("Data1").CopyFromRecordset rst

ActiveSheet.Range("A1:A10000").CopyFromRecordset rst

Oracle Excel Connection anf connectionstring

Data -> From Other Sources->From Data connection Wizard->Other/Advance->Microsoft OLE DB Provider for Oracle-> next-> sever name same as source name -> user name and password and test connection.

get Checked radio button Value

        alert(document.querySelector('input[name = "ProductPermId"]:checked').value);

Javascript populate textbox

    document.getElementById("textbox").innerHTML = "youe teext";




Oracle 12 SQL SERVER link Error JD Edwards

The OLE DB provider "OraOLEDB.Oracle" for linked server "JDED1" supplied inconsistent metadata for a column. The column "MCMCU" (compile-time ordinal 1) of object ""CRPDTA"."F0006"" was reported to have a "LENGTH" of 12 at compile time and 24 at run time.

following is working


Select * from OPENQUERY(JDED1,'SELECT substr(MCMCU,1,12) MCMCU,substr(MCDL01,1,60)MCDL01  FROM CRPDTA.F0006') ORDER BY 1;

Javascript date add days asp

var strDate = new Date('2016-05-14');
strDate.setDate(strDate.getDate() + 17); //number  of days to add, e.x. 17daysvar dateFormated = strDate.toISOString().substr(0,10);

Oracle SQL Developer: How do I copy data with Column Headers from the output Result

Oracle SQL Developer: How do I copy data with Column Headers from the output Result
Shift-Ctrl-C

Format a number with commas SQL Server

select format([Number], 'N0')

select format([Number], 'N2')
2 place of decimal ==> sql server 2012 and +




Aging Report using SQL-Server

declare @AdvanceDate datetime

set @AdvanceDate='02/29/2016'

--select DATEADD(DD,-90,@AdvanceDate)

select

ST, LOB,

case when  cast([Advance Date] as datetime)<DATEADD(DD,0,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-30,@AdvanceDate) then [Current Balance] else 0 end [Age30],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-30,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-60,@AdvanceDate) then [Current Balance] else 0 end [Age60],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-60,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-90,@AdvanceDate) then [Current Balance] else 0 end [Age90],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-90,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-120,@AdvanceDate) then [Current Balance] else 0 end [Age120],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-120,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-150,@AdvanceDate) then [Current Balance] else 0 end [Age150],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-150,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-180,@AdvanceDate) then [Current Balance] else 0 end [Age180],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-180,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-210,@AdvanceDate) then [Current Balance] else 0 end [Age210],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-210,@AdvanceDate) then [Current Balance] else 0 end [Age>210]  into #temp11

--cast([Advance Date] as datetime)[Advance Date]

from #temp1 where  cast([Advance Date] as datetime)<=@AdvanceDate

select

ST,LOB,sum(Age30)Age30,    sum(Age60)Age60,     sum(Age90)Age90,     sum(Age120)Age120,       sum(Age150)Age150,   sum(Age180)Age180, sum(Age210)Age210,    sum([Age>210])[Age>210]

from  #temp11 group by st,[lob]

SQL For Account Balance fix -F0911 vs F0902

--drop table #temp902

select  GBAID,gbsbl,gbsblt,sum(gban01) Period_01  ,sum(gban02) Period_02 ,

sum(gban03) Period_03 ,sum(gban04) Period_04 ,sum(gban05) Period_05 ,sum(gban06) Period_06 ,sum(gban07) Period_07 ,

sum(gban08) Period_08 ,sum(gban09) Period_09 ,sum(gban10) Period_10 ,sum(gban11) Period_11 ,sum(gban12) Period_12 

,sum(gban13) Period_13

into #temp902 from proddta.f0902 where gbco='00600' and gbfy=15 and gblt='AA'

group by GBAID,gbsbl,gbsblt

--having sum(gban01)<>0

delete #temp902 where period_01=0 AND  period_02=0 AND  period_03=0 AND  period_04=0 AND  period_05=0 AND  period_06=0

 AND  period_07=0 AND  period_08=0 AND  period_09=0 AND  period_10=0 AND  period_11=0 AND  period_12=0  and Period_13=0

select glpn, GLAID,GLsbl,GLsblt,sum(GLAA) Amount into #temp1 from proddta.f0911 where glco='00600'  and glfy=15 

and gllt='AA'  and glpost='P'

group by GLAID,GLsbl,GLsblt,glpn

select glpn,GLAID,GLsbl,GLsblt,

case When glpn=1 then amount else 0 end Period_01,  

case When glpn=2 then amount else 0 end Period_02,  

case When glpn=3 then amount else 0 end Period_03,  

case When glpn=4 then amount else 0 end Period_04,  

case When glpn=5 then amount else 0 end Period_05,  

case When glpn=6 then amount else 0 end Period_06,  

case When glpn=7 then amount else 0 end Period_07,  

case When glpn=8 then amount else 0 end Period_08,  

case When glpn=9 then amount else 0 end Period_09,  

case When glpn=10 then amount else 0 end Period_10,  

case When glpn=11 then amount else 0 end Period_11,  

case When glpn=12 then amount else 0 end Period_12 ,

case When glpn=13 then amount else 0 end Period_13 

into #temp2

from #temp1

--drop table #temp3

select GLAID,GLsbl,GLsblt,

Sum(Period_01)Period_01,Sum(Period_02)Period_02,Sum(Period_03)Period_03,Sum(Period_04)Period_04,Sum(Period_05)Period_05,

Sum(Period_06)Period_06,Sum(Period_07)Period_07,Sum(Period_08)Period_08,Sum(Period_09)Period_09,Sum(Period_10)Period_10,

Sum(Period_11)Period_11,Sum(Period_12)Period_12,Sum(Period_13)Period_13 into #temp3

 from #temp2

 group by GLAID,GLsbl,GLsblt

 delete #temp3

 where period_01=0 AND  period_02=0 AND  period_03=0 AND  period_04=0 AND  period_05=0 AND  period_06=0

 AND  period_07=0 AND  period_08=0 AND  period_09=0 AND  period_10=0 AND  period_11=0 AND  period_12=0  and Period_13=0

-- declare @aid varchar(10)='10205217'

--select * from #temp902 where  gbaid=@aid and gbsbl='01424411'

--select * from #temp3 where  glaid=@aid and glsbl='01424411'

--select * from #temp902 order by 1,2,3

--select * from #temp3 order by 1,2,3

select GLAID,GLsbl,GLsblt,a.period_13,b.period_13 from #temp902 a

left outer join #temp3 b on GLAID=GBAID and GLsbl=GBSBL and GLsblt=gbsblt

where 

a.period_13<>b.period_13

Time out when paste 500+ lines in JD Edwards

Time out when try to paste 500+ lines in Journal Entries in JD Edwards 9.1.

 

xkcd is not a valid version for P4314 Error - JD Edwards

When I saw this error I cant believe this, I dont know how to fix , so I created this version xkcd  for P4314.

xkcd is not a valid version for P4314
	A form level error has occurred. Cause..... xkcd is not a valid version for P4314 application.  Resolution.... Specify the correct version for P4314 application in the corresponding processing option.
	ER Details:     Form   P0411B_W0411BA     Control Id   2     Control Title   Select     Event   Button clicked     Line No   22   BSFN Details:     Source File   b0400421.c     Source Line   125     Error ID   0011U

Run Stored Proc and insert data in a Table Without SSIS

--FL
INSERT into [tblpra_FL_cash]
Exec [ServerName].[OtherDatabase].dbo.spMonthlyCashTo820 'FL','01/01/2015','02/29/2016'

Z file check upload process JD Edwards

Z file check upload process


Listing of ER for Report: Report : Inventory Control Location (R550154A)

***********************************************************************
     GLOBALS: Variables (Global)
***********************************************************************
     rpt_DateEffective
     rpt_PhoneAreaCode1
     rpt_PhoneNumber
     rpt_LineNumberID
     rpt_NameGiven
     rpt_NameSurname
     rpt_FaxAreaCode1
     rpt_FaxNumber
     rpt_HubManagerCode1
     rpt_Country
     rpt_ZipCode_Num
     rpt_LenZipCade
     rpt_CustomerCode2
     rpt_AddressNumber_Closed
     rpt_DateClosed
     rpt_DateClosedGE
     rpt_GenericLong
     rpt_GenericLong_Out
     rpt_ReportCodeAddBook019
     rpt_DateBeginningEffective_1
     rpt_LedgType
     rpt_IdentifierShortItem_41021
     rpt_QtyOnHandPrimaryUn41021
     rpt_TotalPrimaryUn
     rpt_AmountUnitCost
     rpt_IndItemPrice
     rpt_TotaItemPrice

=======================================================================
     SECTION: Address Book Update [COLUMNAR SECTION] (S1)
=======================================================================
     OBJECT:  SECTION
     EVENT:  Initialize Section
-----------------------------------------------------------------------
     OPT: Using Defaults
0001 Get Input Output Env Handles
        SL LoginEnvironment -> BF szInputEnvironment
        VA rpt_GenericLong <- bf="" idinputenvhandle="" p="">        SL LoginEnvironment -> BF szOutputEnvironment
        VA rpt_GenericLong_Out <- bf="" idoutputenvhandle="" p="">        SL LoginEnvironment -> BF szLoginEnvironment
0002 Delete All Rows From Table
        "F550154" -> BF szTableName
        VA rpt_GenericLong_Out -> BF idOutputEnvHandle

-----------------------------------------------------------------------
     EVENT:  Do Section
-----------------------------------------------------------------------
     OPT: Using Defaults
0001 F0101 Get Effective Date
        BC Address Number (F0101)(AN8) -> BF mnAddressNumber
        VA rpt_DateEffective <- bf="" jddatebeginningeffective="" p="">0002 F0116 Get Next Effective Address
        BC Address Number (F0101)(AN8) -> BF mnAddressNumber
        VA rpt_DateEffective -> BF jdDateBeginningEffective
        RV Address1 <- bf="" p="" szaddressline1="">        RV ZIP <- bf="" p="" szzipcodepostal="">        RV City <- bf="" p="" szcity="">        RV State <- bf="" p="" szstate="">        VA rpt_Country <- bf="" p="" szcountry="">0003 F0115 Get Primary Phone Number
        BC Address Number (F0101)(AN8) -> BF mnAddressnumber
        VA rpt_PhoneNumber <- bf="" p="" szphonenumber="">        VA rpt_PhoneAreaCode1 <- bf="" p="" szphoneareacode1="">0004 If VA rpt_PhoneNumber is equal to
0005    RV PhoneNo = ""
0006 Else
0007    RV PhoneNo = concat(concat(rtrim([VA rpt_PhoneAreaCode1],' ')," - "),ltrim([VA rpt_PhoneNumber],' '))
0008 End If
0009 //
0010 VA rpt_NameGiven = ""
0011 VA rpt_NameSurname = ""
0012 VA rpt_LineNumberID = 0
0013 F0111.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0014 RV Fname = [VA rpt_NameGiven]
0015 RV Lname = [VA rpt_NameSurname]
0016 //
0017 VA rpt_NameGiven = ""
0018 VA rpt_NameSurname = ""
0019 F0111.Fetch Single
        BC Address Number - 1st (F0101)(AN81) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0020 RV An81_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0021 //
0022 VA rpt_NameGiven = ""
0023 VA rpt_NameSurname = ""
0024 F0111.Fetch Single
        BC Address Number - 2nd (F0101)(AN82) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0025 RV An82_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0026 //
0027 VA rpt_NameGiven = ""
0028 VA rpt_NameSurname = ""
0029 F0111.Fetch Single
        BC Address Number - 3rd (F0101)(AN83) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0030 RV An83_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0031 //
0032 VA rpt_NameGiven = ""
0033 VA rpt_NameSurname = ""
0034 F0111.Fetch Single
        BC Address Number - 4th (F0101)(AN84) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0035 RV An84_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0036 //              CMC2
0037 F0301.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_CustomerCode2 <- 2="" code="" commission="" p="" tk="">0038 VA rpt_NameGiven = ""
0039 VA rpt_NameSurname = ""
0040 F0111.Fetch Single
        VA rpt_CustomerCode2 =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0041 RV CMC2 = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0042 //
0043 VA rpt_LineNumberID = 2
0044 F0115.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_LineNumberID =  TK Line Number ID - 5.0
        VA rpt_FaxAreaCode1 <- p="" phone="" prefix="" tk="">        VA rpt_FaxNumber <- number="" p="" phone="" tk="">0045 If VA rpt_FaxNumber is equal to
0046    RV FaxNo = ""
0047 Else
0048    RV FaxNo = concat(concat(rtrim([VA rpt_FaxAreaCode1],' ')," - "),ltrim([VA rpt_FaxNumber],' '))
0049 End If
0050 F0301.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_HubManagerCode1 <- 1="" code="" commission="" p="" tk="">0051 F0101 Get Alpha Name
        VA rpt_HubManagerCode1 -> BF mnAddressNumber
        RV HubManager <- bf="" p="" szaddressbookdescription="">0052 VA rpt_ZipCode_Num = [RV ZIP]
0053 VA rpt_LenZipCade = length([VA rpt_ZipCode_Num])
0054 If VA rpt_LenZipCade is equal to "4"
0055    RV ZIP = lpad([RV ZIP],'0',5)
0056 Else
0057 End If
0058 RV ZIP = lpad([RV ZIP],'0',5)
0059 //
0060 //
0061 //
0062 // Suppress Write
0063 //
0064 If RV State is equal to Or RV State is equal to "" Or RV State is equal to Or RV State is equal to
0065    Suppress Section Write
0066 End If
0067 If RV State is equal to "  ,AK,HI,PR"
0068    Suppress Section Write
0069 Else
0070 End If
0071 If VA rpt_Country is equal to "US"
0072 Else
0073    Suppress Section Write
0074 End If
0075 If RV Fname is equal to Or RV Fname is equal to "" Or RV Fname is equal to Or RV Fname is equal to ""
0076    Suppress Section Write
0077 End If
0078 //
0079 //
0080 // Date Closed
0081 //
0082 //
0083 VA rpt_DateClosedGE = ""
0084 F550155.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_DateClosed <- -="" date="" expired="" p="" tk="">0085 While SV File_IO_Status is equal to CO SUCCESS
0086    If VA rpt_DateClosed is greater than VA rpt_DateClosedGE
0087       VA rpt_DateClosedGE = VA rpt_DateClosed
0088    Else
0089       VA rpt_DateClosedGE = VA rpt_DateClosedGE
0090    End If
0091    F550155.Fetch Next
           BC Address Number (F0101)(AN8) <- address="" number="" p="" tk="">           VA rpt_DateClosed <- -="" date="" expired="" p="" tk="">0092 End While
0093 RV DateClosed = [VA rpt_DateClosedGE]
0094 //
0095 //
0096 // End Date Closed
0097 //
0098 //
0099 VA rpt_LedgType = "02"
0100 VA rpt_TotaItemPrice = 0
0101 VA rpt_IndItemPrice = 0
0102 VA rpt_AmountUnitCost = 0
0103 VA rpt_QtyOnHandPrimaryUn41021 = 0
0104 F41021.Fetch Single
        VA rpt_IdentifierShortItem_41021 <- -="" item="" number="" p="" short="" tk="">        BC Business Unit (F0101)(MCU) =  TK Business Unit
        VA rpt_QtyOnHandPrimaryUn41021 <- -="" hand="" on="" p="" primary="" quantity="" tk="" units="">0105 While SV File_IO_Status is equal to CO SUCCESS
0106    F4105.Fetch Single
           VA rpt_IdentifierShortItem_41021 =  TK Item Number - Short
           BC Business Unit (F0101)(MCU) =  TK Business Unit
           VA rpt_LedgType =  TK Cost Method
           VA rpt_AmountUnitCost <- -="" amount="" cost="" p="" tk="" unit="">0107    VA rpt_TotaItemPrice = [VA rpt_TotaItemPrice]+([VA rpt_AmountUnitCost]*[VA rpt_QtyOnHandPrimaryUn41021])
0108    F41021.Fetch Next
           VA rpt_IdentifierShortItem_41021 <- -="" item="" number="" p="" short="" tk="">           BC Business Unit (F0101)(MCU) <- business="" p="" tk="" unit="">           VA rpt_QtyOnHandPrimaryUn41021 <- -="" hand="" on="" p="" primary="" quantity="" tk="" units="">0109 End While
0110 //
0111 //
0112 //
0113 //
0114 //
0115 F550154.Insert
        BC Address Number (F0101)(AN8) -> TK Address Number
        BC Business Unit (F0101)(MCU) -> TK Business Unit
        BC Name - Alpha (F0101)(ALPH) -> TK Name - Alpha
        RV Fname -> TK Name - Given
        RV Lname -> TK Name - Surname
        RV HubManager -> TK Description
        RV Address1 -> TK Address Line 1
        RV City -> TK City
        RV State -> TK State
        RV ZIP -> TK Postal Code
        RV PhoneNo -> TK Phone Number
        BC Category Code - Address Book 29 (F0101)(AC29) -> TK Category Code - Address Book 29
        RV FaxNo -> TK Case Fax Number 4
        RV An81_Desc -> TK Address Line 2
        RV An82_Desc -> TK Address Line 3
        RV An83_Desc -> TK Address Line 4
        RV An84_Desc -> TK Address Line 5
        RV CMC2 -> TK Address Line 6
        RV DateClosed -> TK Date Audit File Future Use
        VA rpt_Country -> TK Country
        VA rpt_TotaItemPrice -> TK Amount - Extended Price
        VA rpt_DateClosed -> TK Date - Counted
0116 //
0117 //
0118 //

=======================================================================
     SECTION: Wf- Inv. Control Location [COLUMNAR SECTION] (S3)
=======================================================================
     OBJECT:  SECTION
     EVENT:  Do Section
-----------------------------------------------------------------------
     OPT: Using Defaults
0001 F0101.Fetch Single
        BC Address Number (F550154)(AN8) =  TK Address Number
        VA rpt_DateBeginningEffective_1 <- -="" beginning="" date="" effective="" p="" tk="">        VA rpt_ReportCodeAddBook019 <- -="" 19="" address="" book="" category="" code="" p="" tk="">0002 Get UDC Description (Obsolete)
        "01" -> BF szSystemCode
        "19" -> BF szUserDefinedCodes
        VA rpt_ReportCodeAddBook019 -> BF szUserDefinedCode
        RV AC19Desc <- bf="" p="" szdescription01="">0003 ! VA rpt_ReportCodeAddBook019 = ltrim([VA rpt_ReportCodeAddBook019],'')
0004 ! Get UDC
     !    "01" -> BF szSystemCode
     !    "19" -> BF szRecordTypeCode
     !    VA rpt_ReportCodeAddBook019 -> BF szUserDefinedCode
     !    RV AC19Desc <- bf="" p="" szdescription001="">0005 F0116.Fetch Single
        BC Address Number (F550154)(AN8) =  TK Address Number
        VA rpt_DateBeginningEffective_1 =  TK Date - Beginning Effective
        RV Add2 <- 2="" address="" line="" p="" tk="">0006 //
0007 RV Days = days_between([BC Date - Counted (F550154)(CNTJ)],[SL DateToday])

Wednesday February 17, 2016  08:43

Cancel a PO Line in JD Edwards

Cancel a PO Line in JD Edwards

1. Open P4310, and pull that order  

2.  after that Detail Revisions, 

3.  select the line to cancel and from row exit click on Cancel Line.

Purchase Order - Blankets Release Error JD Edwards 9.1

Purchase Order - Blankets Release Error JD Edwards 9.1

	Requested Date Is Not a Work Day
	Invalid Commodity Code
	Commodity Code has an invalid data dictionary value.

Upload multiple files using fileupload control in Asp Net c#

Upload multiple files using fileupload control in Asp Net

ASP.NET 4.5 brings many new desirable features to upgrade the functionality of previous versions.

Here I will discuss with you one of them, the feature of new the FileUpload control in ASP.NET 4.5. The FileUpload control in ASP.NET extends it's functionality by supporting the upload of multiple files at once.

Prior to this latest version, the FileUpload control only supported a single file at a time, but version ASP.NET version 4.5 solves this issue very well. 

Now, the FileUpload control is built to support HTML 5, therefore it is only supported in browsers supporting HTML5.For other browsers it will work like a normal file upload control in ASP.NET.

A new attribute that comes with the ASP.NET 4.5 FileUplaod control is that:

AllowMultiple: It takes either true or false.




http://www.c-sharpcorner.com/UploadFile/99bb20/upload-multiple-files-using-fileupload-control-in-Asp-Net-4/

Three continuous month and year in SQL Server

Three continuous month and year in SQL eg

Nov 2015
Dec 2015
Jan 2016


Select  left(DateName( month , DateAdd( month , Month(@FCashReceivedDate) , -32 ) ),3)  +' '+ cast(Year(@FCashReceivedDate)  as varchar(4))
Select  left(DateName( month , DateAdd( month , Month(@FCashReceivedDate) , -1 ) ),3)  +' '+ cast(Year(@FCashReceivedDate)  as varchar(4))
Select  left(DateName( month , DateAdd( month , Month(@FCashReceivedDate) , 0 ) ),3)  +' '+   cast(year(DATEADD(year,1,@FCashReceivedDate) ) as varchar(4))

JD Edwards EnterpriseOne Standalone Client Installation Guide

JD Edwards EnterpriseOne Standalone Client Installation Guide

http://docs.oracle.com/cd/E61420_01/EOISA/toc.htm