JD Edwards Debug Application Web client

1. go in task manager->Processes ->jdenet_n.exe 

2. write click and click on debug it will open vc++ window 

3. open your .c business function 

4. put break point 

or 8.12 with vs 2003 here is no need to set Workspace and DLL as like Xe version with VS 6.

U just set exe as per below steps using project option.

1.Open VC++ 2003 version

2.go menu File--> Open--> Project

3. Set jdenet_exe if it is web application or if it is report set active console.exe

from C:\E812\system\bin32 as per in your installation of JDE

Open your C business function file from source

set break point and run your application /report

OR 

U can open processes (jdenet_exe for web application and activeConsole.exe for report) directly from Task manager as per my previous post 

http://www.jdelist.com/ubb/showflat.php?Cat=&Number=149024&Main=148836

http://download.oracle.com/docs/cd/E17984_01/doc.898/e14705/debugging_event_rules.htm

Remane Table Column Name Sql-server

sp_RENAME

'TableName.Columnname', 'NewColumnName' , 'COLUMN'

Sending E-mail to All List of Membership Users with ASP.Net Built-in Membership API

Sending E-mail to All List of Membership Users with ASP.Net Using Built-in Membership API

ASP.Net has a very powerfull built-in membership api and it has all the things we need;

• User Management
• CRUD (Create, Read, Update & Delete) of Membership Model
• User approvement
• Changing password
• Recovering password

And the other things. Also, it is safe to say so many developer use this magical thing. 

The registered users are so important to our company and we want to let them know we live and our new things once in a while. As a result, newsletters' main purpose is that.

But how can we send e-mail to all of the registered users inside our magical Membership SQL Database? There are some ways but here we will see the simple and most useful way. We will be talking to database of course in order to get the e-mail addresses but we won't be directly talking to membership database. ASP.Net has already done that for us. 

http://www.tugberkugurlu.com/archive/sending-e-mail-to-all-list-of-membership-users-with-asp-net-using-built-in-membership-api

Execute SSIS from Batch file

Using this to execute SSIS
dtexec /f "C:\tempssis\ProviderAddressBook 1.dtsx"

Custom ASP.NET Routing to an HttpHandler

As of version 4.0 ASP.NET natively supports routing via the now built-in System.Web.Routing namespace. Routing features are automatically integrated into the HtttpRuntime via a few custom interfaces.

http://www.west-wind.com/weblog/posts/974489.aspx

JD Edwards Fixing Advance Pricing data F4074..

drop table jde_rk.dbo.tempadprc
select distinct sddoco addoco ,sdlnid adlnid  into jde_rk.dbo.tempadprc from jde_production.proddta.f4211 
left outer join jde_production.proddta.f4074 on sddoco=aldoco and  sddcto=aldcto and  sdkcoo=alkcoo and sdlnid=allnid and ALOSEQ=0
where sdlttr != '980' AND sddcto='SO' and sdlnty='S' AND SDTRDJ  > 111000  and aldoco is null
and sdkcoo in ('00667')

 

insert jde_production.proddta.f4074
select
sddoco ALDOCO,sddcto ALDCTO,sdkcoo ALKCOO,'' ALSFXO,sdlnid ALLNID,0 ALAKID,'' ALSRCFD,0 ALOSEQ,0 ALSUBSEQ,0 ALTIER,'' ALASN,'' ALAST,
sditm ALITM,0 ALAN8,sdcrcd ALCRCD,sduom ALUOM,0 ALMNQ,'' ALLEDG,'' ALFRMN,'' ALBSCD,(sdsoqs*10000)ALFVTR,'' ALABAS,Sduprc ALUPRC,
0 ALFUP,'' ALGLC,'' ALARSN,'' ALACNT,'' ALSBIF,'' ALMDED,1 ALPROV,0 ALATID,0 ALIGID,0 ALCGID,0 ALOGID,0 ALANPS,0 ALBSDVAL,'' ALSRFLAG,
'' ALADJCAL,0 ALNBRORD,'' ALUOMVID,'' ALOLVL,'' ALADJSTS,'' ALADJREF,0 ALACCAN8,0 ALBNAD,'' ALADJGRP,'' ALMEADJ,'' ALFVUM,'' ALPDCL,
0 ALCFGID,0 ALCFGCID,''ALAPRP1,''ALAPRP2,''ALAPRP3,''ALAPRP4,''ALAPRP5,''ALAPRP6,''ALNDPI,'SQLFIX'ALUSER,'SQLFIX'ALPID,'SQLFIX'ALJOBN,
'111094' ALUPMJ,sdtday ALTDAY,'' ALPMTN,'' ALRULENAME,'' ALPA04
from jde_production.proddta.f4211
left outer join jde_rk.dbo.tempadprc on sddoco=addoco and sdlnid=adlnid
where  addoco is not null