Microsoft Dynamics Axapta Technical,Functional Coverage

Posts

Showing posts with the label insert data into the table

Example of insert recordset in to table using axapta

syntax of insert recordset is insert_recordset DestinationTable ( ListOfFields ) select ListOfFields1 from SourceTable [ where WhereClause ] [ join ListOfFields2 from JoinedSourceTable [ where JoinedWhereClause ]] example of insert recordset is insert_recordset TableName (field1, field2) select field1, field2 from table2 where abc<= 1000;