Question Pedro Lopes · Nov 15, 2023 Error <LIST>%SerializeObject+5 Does anyone happen to know what could be causing this error? ERREUR #5002:Erreur Caché : <LIST>%SerializeObject+5 ^AHP.WebSrvExchange.Response.FicheRetourResponse.1 #Interoperability #Caché #Ensemble 0 3 0 258
Question Pedro Lopes · Aug 31, 2023 SELECT command within CSP The program below works perfectly when I call it directly from the Terminal, however when I call it from within a CSP it does not work (It does not do the SELECT). In the USER namespace, the program works both in the Terminal and on the CSP , but in another namespace it only works when called directly in the Terminal. #CSP #SQL #Caché #InterSystems IRIS 0 4 0 256
Question Pedro Lopes · Aug 9, 2023 What is the correct way to file the ID of a relationship? Class Contatos.Amiguinho Extends %Persistent{Property Moradia As Cidade; Relationship Trabalho As Contatos.Empresa [ Cardinality = one, Inverse = Nomedaempresa ];} #ObjectScript #Relational Tables #Caché 0 15 0 175
Question Pedro Lopes · Jul 26, 2023 How do I retrieve the name of the first GLOBAL from within the GLOBAL directory? How do I retrieve the name of the first GLOBAL from within the GLOBAL directory?Should I use some syntax with $Order or $Query or is there another way? #Globals #InterSystems IRIS 0 3 0 161
Question Pedro Lopes · May 12, 2023 How to file with SQL for CARDINALITY=many If I had:________________________________________Class MN.Student Extends %Persistent{Property Name As %String;________________________________________Class MN.Course Extends %Persistent{Property TeacherName As %String;Relationship StudentName As MN.Student [ Cardinality = one, Inverse = Name ];________________________________________ For "Cardinality = one" the SQL line below would be sufficient for archivingINSERT INTO MN.Course (TeacherName, StudentName) VALUES ('Pierre','3')" #SQL #InterSystems IRIS 0 1 0 136
Question Pedro Lopes · Feb 3, 2023 List properties I would like to know how I can make a utility to retrieve all the names of properties of a class. Any idea? #Caché 0 5 0 382