This content has been marked as final. Show 4 replies
This is a simple piece of code which is used to retrieve values from a record (which is defined in the SQL object) into an array. The While loop goes through all the rows retrieved from the SQL.
You can retrieve values from the array by using &AAny;. Each number within the [ ] represents the position in the array (see it as the column number of the record).
&AAny = CreateArrayAny; &SQL = GetSQL(SQL.TEST_SQL); While &SQL.Fetch(&AAny) /* Do something */ End-While; &SQL.Close();
More info on Arrays: