Question Henry Pereira · Oct 15, 2022 Metaprogramming in ObjectScript With $Property is possible to dynamically get and set values on property of an instanced class and with $ClassMethod is possible to invoke methods from a class. I would like to know: Is there an elegant way to do Write and Set dynamically on variables without using Xecute? #ObjectScript #Caché #InterSystems IRIS 0 6 0 233
Question Henry Pereira · Mar 12, 2021 Hierarchical Queries Hi community, I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow: #Caché 0 4 0 215
Question Henry Pereira · May 20, 2020 How to select a random row from a table? Hi community, I need to write an SQL query to fetch a random record from a table, that table has millions of data. In postgresql, for example, there is a RANDOM() function to do something like that: SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Is it possible to do something like that in Caché? Thanks in advance #Caché #InterSystems IRIS 0 8 0 623