#1
|
|||
|
|||
select_from_ltab
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?
|
#2
|
|||
|
|||
re: select_from_ltab
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
|
#3
|
|||
|
|||
re: select_from_ltab
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
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | Search this Thread |
Display Modes | Rate This Thread |
|
|