Generates a select statement that selects all the fields from a chosen record.
Typically, when you use the %SelectAll, you would use a record object to store the results. That way you don’t have to know how many fields your result will return.
Examples
%SelectAll(JOB)
Local Record &myRecord;
&myRecord = CreateRecord(RECORD.MY_RECORD);
SQLExec(“%SelectAll(:1) WHERE MY_KEY = :2”, &myRecord, “My Key”, &myRecord);
Local Record &myInstallation;
&myRecord = CreateRecord(RECORD.INSTALLATION);
SQLExec(“%SelectAll(:1)”, &RECORD.INSTALLATION, &myInstallation);