Tuesday, 11 September 2012

Adding and updating data into record in peoplecode
&variable_name= CreateRecord(Record.Record_name);
&variable_name.field_name.value= data
&variable_name.field_name2.value= data
/*to insert new row*/
&variable_name.Insert()
/*to update existing data*/
&variable_name.update()
Note: when doing update key field’s data required
          If with same key fields data is already exist in table insert will not work

To get field name of that record

For &i = 1 To &variable_name.FieldCount
   &fn = &variable_nameGetField(&i).Name;

No comments:

Post a Comment