Insert_recordset and update_recordset usage

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


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;


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s