All
Accepted answers
James Woo · Mar 24, 2022 go to post

Where can I find the Config.Database class?

Config.DatabasesConfig.Database class
James Woo · Mar 17, 2022 go to post

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 ^||fruit
CLOSE myf
s tLine = ""
d tmpFile.Rewind()
while ('tmpFile.AtEnd) {
set tLine = tLine_tmpFile.ReadLine()
}
d ##class(%File).Delete(myf)
w tLine

James Woo · Aug 25, 2020 go to post

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 ];

James Woo · Feb 10, 2020 go to post

Took the easy way out by reading the source file and write it out to the destination file

James Woo · Jan 20, 2020 go to post

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).

James Woo · Dec 16, 2019 go to post

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.

James Woo · Jan 11, 2019 go to post

Yes, I've been using the AVG function. Any solution will do. Any sample code out there? Thanks

James Woo · Jan 11, 2019 go to post

That's great, but unfortunately, we've not upgraded to the latest and greatest. We're still using the 2015 release.