Re: [Axapta-Knowledge-Village] Best way to delete DEL_ fields?
Hi,
To delete all the DEL_ objects go to administration module - system
submenu - Configuration - open the Administration node - Uncheck the Keep
Update Objects checkbox. Now synchronize. this should remove all the DEL_
objects from the system. the DEL_ objects are associated with the
SysDeletedObjects40 configuration key, which is deactivated by unchecking the
configuration setting and hence the objects are removed.
Regards
Pathikrit
- Original Message
From: padmaja_wipro [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, 21 February, 2008 3:14:18 AM
Subject: [Axapta-Knowledge-Village] Best way to delete DEL_ fields?
Hi,
I would like to delete the fields that were obsolete during
upgradation. I have to delete one field that starts with DEL_ from a
table. Please note that this field is at sys layer in the table..
So to delete that, do I need to delete from SQLDictonary table which
is a system table?
Did anyone have tried to delete DEL fields?. if so, what the best way
to do this?
Thanks in advance.
Padma
!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#ff;text-decoration:none;}
--
!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
--
!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
--
Why delete messages? Unlimited storage is just a click away. Go to
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] EP Customizations disappearing
Thanks for the suggestions, the actual problem in our case was that there was frequent porting of the layer file between the development and testing environments and the page definations were not getting deployed properly. Regards Pathikrit - Original Message From: SARAVANAN .J [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, September 25, 2007 6:49:41 PM Subject: Re: [Axapta-Knowledge-Village] EP Customizations disappearing Hi, If the customizatomized web forms are not visible in the web page, then check whether datsource is attached to the grid in th web form. If the web form is working fine, and the only problem is with the opening of web page. then try deploying the web page. right click on the page definition and then deploy the web page. If this too doesnt work then go to the admin module -- setup -- internet -- manage deployment. and then do the deployment. But before all these things have you gone through event viewer to see what is the error. Because as far as i know if the web form has some errors then the web page will not be shown. check on the second time opening of web page whether you logic throws any exceptions that needs to be handled. Regards, Saravanan J pathikrit das pathikrit_82@ yahoo.com wrote: Hi all, We are developing in MS Dynamics AX 4.0 EP environment on MOSS 2007 platform.Developmen t is in var layer. The web part pages show perfectly displaying the corresponding web forms, reports and web menus that are embedded into it. However after a while when that page is opened again it opens blank. In design mode it shows the controls for the web parts but not the actual web parts (the dynamics properties of the individual web parts are also not accessible). We have tried all kinds of refreshing options but to no avail. A critical thing is that when the system web parts are modified they show in EP, it is only the web parts developed in var layer that are disappearing after some time. Any help will be appreciated. Regards Pathikrit _ _ _ _ _ _ Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games. yahoo.com/ proddesc? gamekey=monopoly herenow [Non-text portions of this message have been removed] - - --- Did you know? You can CHAT without downloading messenger. Click here [Non-text portions of this message have been removed] Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mailp=graduation+giftscs=bz [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] select with force_placeholders
The keyword force_placeholder will force the kernel to select data using a
prepared select. Used to overrule the default forceliterals in join on large
(complex) tables. The kernel default select uses
forceplaceholders when not selecting from large tables.All tables except those
with TableGroup property group or parameter are considered complex by
the AX kernel.
If you want to use the group by clause you need to mention the field using
addsortfield, coz otherwise the group by won't work. I get that you want join
between 2 tables one of which you want to sort group by and other one order
by. I am not sure whether this is possible and will get back if I find anything
Cheers
Pathikrit
- Original Message
From: anton_tjiptadi [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, May 22, 2007 2:42:25 PM
Subject: [Axapta-Knowledge-Village] select with force_placeholders
does anyone know what is select with force_placeholder means?
also is it possible to grouping with QueryBuildDataSourc e without
using key addSortField ?
common query is like this for example:
QueryBuildDataSourc e qbds;
Query q = new query();
QueryRun qr;
InventDim Inventdim;
;
qbds = q.addDataSource( tablenum( InventDim) );
qbds.addSortField( fieldnumInventDi m, configid);
qbds.addSortField( fieldnumInventDi m, inventBatchId) ;
qbds.ordermode( ordermode: :groupby) ;
qr = new QueryRun(q);
while (qr.next())
{
...
}
above statement produce grouping by configid ascending and
inventbatchid ascending order.
The problem is I want to join with another table (InventBatch) which
is I want to make order not in InventBatchId, but ExpireDate, so it
will conflict with the firt query (InventBatchId asc) bcoz might be
in second table (Inventbatch) , the ExpDate sorted but not the
inventBatchId.
please help,
thx,
Ton.
!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
--
Pinpoint
customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Classes with Ax Prefix
They actually provide an interface for safe I/O of data from an external source
(ex : XML document ) to the axapta base tables following the application logic
validations concerned. The name of the classes suggest their association with
the respective tables (AxCustTable - CustTable). You can also use them to
create records on the respective tables from X++.
- Original Message
From: helloworld4all [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, April 26, 2007 3:57:54 PM
Subject: [Axapta-Knowledge-Village] Classes with Ax Prefix
Hi All,
Axapta has a lot of classes having prefix 'Ax' like
axcusttable, axpurchtable etc. what is the significance of these classes?
what is the purpose of using these classes?
Regards,
Mukesh Kumar
!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
--
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] AX 3.0, Vista and IIS
I don't think you can configure EP on Windows Vista, since it is not
essentially meant to be used as a server OS, it doesn't come with the
pre-loaded IIS, ideally you should be setting it up on the windows 2003 server.
- Original Message
From: per_biker [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Friday, April 27, 2007 6:12:17 PM
Subject: [Axapta-Knowledge-Village] AX 3.0, Vista and IIS
Have any of you got the EP up running on a windows vista.
Right now im stuck at the message 'cannot find the internet infoemation
server, please make sure that it is properly installed on the local
machine'
Thanks in advance
Per jakobsen
!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
--
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
