go to post James Woo · Mar 24, 2022 Where can I find the Config.Database class? Config.DatabasesConfig.Database class
go to post James Woo · Mar 17, 2022 https://openexchange.intersystems.com/package/IO-Redirect s tmpFile = ##class(%FileCharacterStream).%New()s myf = tmpFile.Filename = ##class(%File).TempFilename("txt") open myf:("NW") USE myf ZWRITE ^||fruitCLOSE myfs tLine = ""d tmpFile.Rewind()while ('tmpFile.AtEnd) {set tLine = tLine_tmpFile.ReadLine()}d ##class(%File).Delete(myf)w tLine
go to post James Woo · Aug 25, 2020 Have you try the following: Index fcIDX1 On (Invoice(ELEMENTS), Invoice(KEYS)) [ Type = index ]; Index fcIDX2 On Invoice(KEYS) [ Type = index ]; Property Invoice As list Of %String(SQLTABLENAME = "INVOICETABLE", STORAGEDEFAULT = "array") [ SqlFieldName = INVOICE ];
go to post James Woo · Feb 10, 2020 Took the easy way out by reading the source file and write it out to the destination file
go to post James Woo · Jan 20, 2020 Other than the obvious syntax error like '%[^a-zA-Z0-9 !”%#$&”()*+,-./:\;<=>?@]%' ,the query fails to return anything at all (Special character or no special characters).
go to post James Woo · Dec 16, 2019 First, I have to use the ODBC Data Source Administrator to add and configure a System DSN for my namespace. Then I added the newly created DSN name to the SQL inbound adapter setting.
go to post James Woo · Jan 11, 2019 Yes, I've been using the AVG function. Any solution will do. Any sample code out there? Thanks
go to post James Woo · Jan 11, 2019 That's great, but unfortunately, we've not upgraded to the latest and greatest. We're still using the 2015 release.
