go to post Robert Cemper · Aug 15, 2023 Not a ready-to-use solution, but a way to take export the global by SMP or embed %system.OBJ.Export to create *.XML file download it using <a href="~file_location~" download> explanation
go to post Robert Cemper · Aug 14, 2023 With JOB you start an independent process in background.You can pass any variable you may need.But you can't pass the connection to the CSP page with all its settings.the connection stays with the foreground job.
go to post Robert Cemper · Aug 12, 2023 there is a standard utility %ETN that writes such logs with the stack and all other $system variables into the global ERRORsif you call it by LOG^%ETN it does a kind of snapshotdetails here take a look
go to post Robert Cemper · Aug 11, 2023 not usable for Docker Windows Desktop KITVERSION=latest is just wishful thinking 😒😟
go to post Robert Cemper · Aug 11, 2023 Are community images from intersystemsdc/ also affected ? this may relate to all templates on OEX and also 430 packages on OEX using docker
go to post Robert Cemper · Aug 10, 2023 example moved here Remote Global Listing using NativeAPI for ObjectScript #1
go to post Robert Cemper · Aug 9, 2023 According to class Class Contatos.Amiguinho you presented Class Contatos.Empresa should look similar to this to work: Class Contatos.Empresa Extends %Persistent { Relationship Nomedaempresa As Contatos.Amiguinho [ Cardinality = many, Inverse = Trabalho ]; Property Nome As %String; Storage Default }
go to post Robert Cemper · Aug 9, 2023 you may run an export ^%G like on the remote server and then copy somehow the result
go to post Robert Cemper · Aug 9, 2023 It's an orgy of IsDefined ($DATA) and GetNext( $ORDER) as equivalent of $QUERY is not implemented
go to post Robert Cemper · Aug 9, 2023 sorry, Insert() is only for the "MANY" side of the Relationship
go to post Robert Cemper · Aug 9, 2023 You just can insert existing IDs.So you have to check first: set emp=##class(Contatos.Empresa).%OpenId(IDt)if $isObject(emp) Do objcontato.Trabalho.Insert(emp)
go to post Robert Cemper · Aug 9, 2023 Relationship is an Object concept that has no direct equivalent in SQL to handle itThe "MANY" end is basically just a piece of code ( RelationshipObject) to handle it.By SQL you just can set it indirectly from the "ONE" end as you found yourself.This is a real Property / Column that has a distinct value that you can touch and set
go to post Robert Cemper · Aug 9, 2023 Instead of Set Set objcontato.Trabalho=##class(Contatos.Empresa).%OpenId(IDt) you need to use method Insert()Do objcontato.Trabalho.Insert(##class(Contatos.Empresa).%OpenId(IDt)) See Docs
go to post Robert Cemper · Aug 8, 2023 My 5th Choice: use Native API for ObjectScript for access. especially %Net.DB.Iris
go to post Robert Cemper · Aug 8, 2023 My 4rd Choice: as you have access export the Global to a file copy the file using SSCP
go to post Robert Cemper · Aug 8, 2023 My 3rd Choice: get a network file connection to the source DB mount the DB over the network as remote drive mixing file systems Win / *UX might be tricky
go to post Robert Cemper · Aug 8, 2023 My Second Choice: connect to the server over SQLgateway (Odbc, Jdbc). use Global Dump to SQL
