This is krishna, I created new Table,Bc,Link,Bo,view,screen TABLE : CX_ECB_S_TAT BC : ECB TAT BC Link : ECB TAT BC/Service Request Bo : ECB TAT BO View : ECB TAT View Screen : ECB TAT Screen and I created new "X_ECB_TAT_ID" Column for foregin key relation ship in "S_SRV_REQ" Table [in colum properties I specified Forieignkey Table-CX_ECB_S_TAT] and I created "TAT Id Ext" Field with "X_ECB_TAT_ID" Column in "Service Request" BC. I created Link"ECB TAT BC/Service Request". in this link I specified "Destination Field-TAT Id EXT".( Parent BC : ECB TAT BC, Child BC : Service Request) --------------------------------------------------- There is two Screens 1)ECB TAT Screen 2)Service Request Screen in First Screen : ECB TAT Screen Parent BC : ECB TAT BC Fields : Type,Area,Sub Area,TAT I given the field values to Type,Area,Sub Area and based on field values I given "TAT" field value. now we will go to Second Screen : Service Request Screen Child BC : Service Request Fields : INS Product,INS Area,INS Sub-Area,TAT I given same values(Parent bc Field Values) to INS Product,INS Area,INS Sub-Area then should be update "TAT" Field value (I mean Parent BC same "TAT" Field vaue should be update in "TAT" Field in Child BC) I wrote script for above requirement in "SetFieldValue" Event in "ECB TAT BC" function BusComp_PreSetFieldValue (FieldName, FieldValue) { if(FieldName == "TAT") { var Bo = TheApplication().GetBusObject("ECB TAT BO"); var Bc = Bo.GetBusComp("Service Request"); this.ActivateField("Type"); this.ActivateField("Area"); this.ActivateField("Sub Area"); this.ActivateField("TAT"); var sType = this.GetFieldValue("Type"); var sArea = this.GetFieldValue("Area"); var sSubArea = this.GetFieldValue("Sub Area"); var sTAT = FieldValue; //this.GetFieldValue("TAT"); var Bc1 = Bo.GetBusComp("Service Request") with(Bc1) { var exp = "[INS Product] = '" + sType + "' AND [INS Area] = '" + sArea + "' AND [INS Sub-Area] = '" + sSubArea + "'"; ActivateField("INS Product"); ActivateField("INS Area"); ActivateField("INS Sub-Area"); ClearToQuery(); SetViewMode(AllView); SetSearchExpr(exp); ExecuteQuery(ForwardOnly); var cnt = CountRecords(); ActivateField("TAT"); var fst = FirstRecord(); while(fst) { SetFieldValue("TAT",sTAT); fst = NextRecord(); } } } return(ContinueOperation); } but in "Service Request" BC "TAT" field value updating existing records,not updating creating new necords. I should update "TAT" field value to creating new records. where I have to write script in which event in which BC for this. please post detail script for this. from last 15 days i'm working on this. please help me on this. thank you so much in advance.
2 5283Post New Ecobank Siebel Interview Questions
What peculiar characteristic do the hippopotamus and tapir share?
cement required for construction of 400mm*200mm*200mm concrete solid blocks for 1sq.mtrs,how?
I want to open particular list of members inside pds.Let me know whether below code will work.if not tell me how it works INPUT='DDM.DATASET(AAA*)' X = OUTTRAP(MEMS.)
What is NABARD and tell some of its functions?
What is void main () in c?
What is the use of Php variables?
How do I remove a sign in excel?
Stator of 3-phase IM has 3 slots per pole per phase. If supply frequency is 50 Hz, calculate the speed of rotating stator flux A 1000 rpm B 500 rpm C 1500 rpm D 1440 rpm
Give me an example of a time when you motivated others.
project,planning, equioment erraction &maint format. project,planning&scheduling,bar chart
What is ioc and di?
WHAT IS THE QUALITIES OF UCOBANK AND HOW POSITION IN INDIAN BANKING.
why do you want to work with aspiring minds?
How we can call a jsp from the servlet?
Plese give us information Service Special Tools for Hydraulic,Trasmission,Main clucth,Rear axle etc for Mahindra Tractor 6030-4WD,Like SST Number,Discription,Price and Dimension or Photograph if u have.Thanks