go to post Cristiano Silva · Apr 26 @Rochdi Badis You need to create a instance of %SQL.Statement with the first parameter of %New method iqual 2. #Dim stmt As %SQL.Statement = ##Class(%SQL.Statement).%New(2) For more details see https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_dynsql#GSQL_dynsql_objinstance
go to post Cristiano Silva · Apr 25 @Punit Shah you right. Sorry by not warning about it. You can use some methods of %File class to help. DirectoryExists CreateDirectory CreateDirectoryChain CreateNewDir
go to post Cristiano Silva · Apr 25 @Punit Shah Remeber that if the file already exists, new writes will be appended to end of the file.
go to post Cristiano Silva · Apr 24 Hi @Punit Shah Use the method LinkToFile below a example. C:\temp before create the file: Execute the code Set file = ##Class(%Stream.FileBinary).%New() Set statusCode = file.LinkToFile("c:\temp\test_file.txt") If ($System.Status.IsError(statusCode)) { Do $System.Status.DisplayError(statusCode) Return } Do file.WriteLine($ListBuild("Some bin data")) Write $System.Status.DisplayError(file.%Save()) After execution:
go to post Cristiano Silva · Apr 20 only uninstall option is the unattended section at https://docs.intersystems.com/ens201817/csp/docbook/DocBook.UI.Page.cls?... You can use add or remove programs too. would I be correct to interpret 'CacheC' in the example command as the instance name of the Ensemble installation to be uninstalled? Or is that the folder name on the filesystem where it is in installed? Is the instance name. Not familiar with Windows Registry editing, so can I safely delete those two trees in the registry if i want a completely fresh start? After uninstall and if you have only one installation yes.
go to post Cristiano Silva · Apr 20 Below you find information about Installation and Uninstallation https://docs.intersystems.com/ens201817/csp/docbook/DocBook.UI.Page.cls?KEY=GCI_windows About the register this two tree are created: HKEY_CURRENT_USER\Software\InterSystems HKEY_LOCAL_MACHINE\SOFTWARE\Intersystems
go to post Cristiano Silva · Mar 21 Hi Dmitrii Baranov, I think that a better approch is that you create a new class that extends the original class and change only the method that you need.
go to post Cristiano Silva · Feb 3 Hi Pedro, You can retrieve this information querying the class %Dictionary.PropertyDefinition. An example: SELECT Name FROM %Dictionary.PropertyDefinition WHERE parent = "mypackage.MyClassName" The field parent is fully qualified name of the class that you want to list properties name.
go to post Cristiano Silva · Jan 12 HI @Freddy Baier You can change your query, given alias to the columns: SELECT id,room,client->name as ClientName,functionary->name as FunctionaryName FROM rooms ORDER BY id Then in COS you access the columns by name: Write rs.%Get("ClientName") Write rs.%Get("FunctionaryName")