#------------------------------------------------------------ # Test for skiphiddedn # This option is created by Ilia Sotnikov. # Thank you, Ilia. #-------------------------------------------------------------- # 1. SELECT(with no params) #-------------------------------------------------------------- NO NAME DEPT SECRET MAIL 1 Emp1 1st row real:1 Emp1@com H Mr.Hide HIDDEN real:2 Wmm&. 2 Emp2 2nd row real:3 hoge@mail #-------------------------------------------------------------- # 2. SELECT(vtbl) #-------------------------------------------------------------- NAME DEPT SECRET Emp1 1st row real:1 Mr.Hide HIDDEN real:2 #-------------------------------------------------------------- # 3. SELECT(with condition) #-------------------------------------------------------------- NAME Mr.Hide #-------------------------------------------------------------- # 4. SELECT(vtbl:with condition) #-------------------------------------------------------------- NAME Emp1 Mr.Hide #============================================================== # SKIPHIDDEN #============================================================== #-------------------------------------------------------------- # 1. SELECT(with no params, skip hiddedn) #-------------------------------------------------------------- NO NAME DEPT MAIL 1 Emp1 1st row Emp1@com 2 Emp2 2nd row hoge@mail #-------------------------------------------------------------- # 2. SELECT(vtbl, skip hidden) #-------------------------------------------------------------- NAME DEPT Emp1 1st row Emp2 2nd row #-------------------------------------------------------------- # 3. SELECT(with condition) #-------------------------------------------------------------- NAME #-------------------------------------------------------------- # 4. SELECT(vtbl:with condition) #-------------------------------------------------------------- NAME Emp1 #============================================================== # SKIPHIDDEN+IGONORECASE #============================================================== #-------------------------------------------------------------- # 1. SELECT(with no params, skip hiddedn) #-------------------------------------------------------------- NO NAME DEPT MAIL 1 Emp1 1st row Emp1@com 2 Emp2 2nd row hoge@mail #-------------------------------------------------------------- # 2. SELECT(vtbl, skip hidden) #-------------------------------------------------------------- NAME DEPT Emp1 1st row Emp2 2nd row #-------------------------------------------------------------- # 3. SELECT(with condition) #-------------------------------------------------------------- NAME #-------------------------------------------------------------- # 4. SELECT(vtbl:with condition) #-------------------------------------------------------------- NAME Emp1