Insert_recordset and update_recordset usage

Hi,
Insert_recordset and update_recordset are used to insert or update multiple records correspondingly without using while statements.

Example:

The above code updates designation of the employees which have belowas “AX” to “Technical consultant”.

static void update_recordset(Args _args)
{
Employee Employee ;
;
update_recordset Employee
setting Designation= “Technical consultant”
where Employee .department== “AX”;
}

The below code inserts all the data from custtable to Customer table.

static void insert_recordset(Args _args)
{
custtable custtable;
Customer Customer;
;

insert_recordset Customer(custaccount, custname)
select custaccount, custname from custtable;
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s