Select_from_ltab

[Peter Boks]

Tis example comes from the ME10 helpfile: To select all rows in the user table "data_points" where column 1 is greater than 10, use: SELECT_FROM_LTAB "data_points" COLUMN 1 > 10 END Assuming "data_points" contains: 1 20 5 25 10 11 22 17 43 13 After the command "sys_select" will contain: 4 5 I don't understand this. I would say "sys_select contains: 2 4 6 7 8 9 10. Am I right or wrong? Does anybody know?

[Bruce Fisher]

Peter, I think you are correct and the example is incorrect. Try building a sample table and run the command on it to see for yourself. It won't be the first time the helpfile was wrong. Bruce

[Hannes]

The example is correct. The table contains 5 rows with 2 columns: column 1 contains 1, 5, 10, 22, 43; column 2 contains 20, 25, 11, 17, 13. "sys_select" contains 4 (22) & 5 (43). Hannes