Question Anderson Negreli · Jan 2, 2023 Encoding error in Studio output - Embedded Python Hello, good afternoon! (or good morning or good evening) I was doing some very basic tests, based on the documentation, using Python in Studio.I decided to call a python method through the Studio's own terminal as a demonstration, but the result was different from the terminal result:Code: #Embedded Python #Studio #InterSystems IRIS 1 3 0 221
Question Anderson Negreli · Dec 26, 2022 SQL in Config.ConfigFile returns with fatal error Hello,I tested the query on the Config.ConfigFile table of the Namespace %SYS, it returned 3 lines and a fatal error: #SQL #InterSystems IRIS 0 6 0 238
Question Anderson Negreli · Mar 25, 2021 How to get the row number in an SQL query? Hi, I'm doing a query in SQL and I need to sort my data by some non-repeated field. Unfortunately, my data is grouped in a way that I cannot guarantee that any column will not have repeated data, so one solution would be to take the row number. Also, the Cache is not accepting Row_Number () in my querry and I would like to know if there is another solution to return line numbers or some way to add this function to the Cache. Best regards. #SQL #Caché 12 7 0 3K
Question Anderson Negreli · Jan 14, 2021 Page break - Zen Report I have two tables in a row in my report, but if the first table gets too big to the point that tables 1 and 2 don't fit on the page, the page breaks. The problem is that the page break is happening in the middle of table 2 and I wanted the page to break and leave table 2 on the second page. No table grows to the point of occupying more than one page alone. Any tips on how to guarantee this? Remembering that the reports were made using Zen Report. #ZEN #Caché 2 1 0 231