✏️ Explanatory Question
Use a select method to declare the data that will be modified.
The select statement will fetch or manipulate date from the database using X++. You can use the select statement to fetch one record or field. You can use other statements such as next to fetch additional records, or use a while select to traverse multiple records.
For example, the following code sample will fetch all columns in the first row of the CustTable, then it will print the value in the AccountNum column of that row:
CustTable custTable;
//this is a short notation for 'select firstonly * from custTable;'
select firstonly custTable;
info("AccountNum: " + custTable.AccountNum);