Calculate the result dynamically before save......

[vijet]

Hi Guys,

Thanks a million........ with all your help i was able to get the values... 

Your suggessions were very good and helped me a lot..........

and amdisuk   i will see that i follow the java rules while coding......

MboRemote CompRecord =result.getMbo(0);

Should be

MboRemote compRecord =result.getMbo(0);

Thanks
Vijet

[amdisuk]

Glad we could help!!!!

See that you come back and ask qustions or answer questions!!!!

Thats how the forum will work!!!!

[vijet]

Sure i will be a part of this forum now....

By the way the only changes i made thanks to you both is removing the save which i was using and also used the sum() method ... that eliminated the for loop and also i could do everything in the fld class...
i will post the last working code as this might be usefull for a newbee like me........

MboRemote mbo = (ComponentsMBO)getMboValue().getMbo();
double precost = 0;
MboValue Estcost = getMboValue();
if(mbo instanceof ComponentsMBO)
{
precost = ((ComponentsMBO)Estcost.getMbo()).getThisMboSet().sum("ESTCOST");
MboRemote compRecord=mbo.getOwner();
String setval = Double.toString(precost); /* b'cos the field where i set is ALN */
compRecord.setValue("COSTSUMMARY", setval);
}

I could finish the coding in four lines... !!

[aashish]

Hi Frns ,
I am also trying to same concept ,
bt my problem is with mbosetremote ....its nt fetching value at "itemcost" field ..value is coming only zero evrytime...
Pls Sugggest me..
==============================================================================
                    SqlFormat sqlf2 = new SqlFormat("1=2");
                    Mbo mbo=getMboValue().getMbo();
                              MboRemote mboremote = mbo.getOwner();                                 //owner is Asset
               MboSetRemote ttcost = mboremote.getMboSet("$client", "CLIENT", sqlf2.format());
                 
               if(mbo != null )      
         {                       
            double assetcost=mboremote.getDouble("totalitemcost");
                                double displayitemcost=mboremote.getDouble("itemcost");             // nt fetching value,alws coming 0 value
                 double totalcost=ttcost.sum("itemcost");                                 // nt fetching value,alws coming 0 value
                           double diffcost=Math.abs(assetcost-totalcost);
                                                 
                             Object param[] = {            diffcost  };
================================================================================================

[Yesterday]

• Taskrunner error CTGIN22... by LEUCIR [Yesterday at 01:11:50 pm]
• PM Estimated Due Date whe... by canislupus [May 21, 2012, 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [May 21, 2012, 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [May 21, 2012, 12:26:23 pm]
• add user access by Sarbjeet.Jassal [May 21, 2012, 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [May 21, 2012, 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]