Skip to main content

Posts

Showing posts with the label Axapta Tips hints trick

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;