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
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
It's in the %SYS namespace
go to post
Where can I find the Config.Database class?
go to post
https://openexchange.intersystems.com/package/IO-Redirect
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
go to post
Oops. Never mind. Question is not valid
go to post
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
Took the easy way out by reading the source file and write it out to the destination file
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).
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.
go to post
Yes, I've been using the AVG function. Any solution will do. Any sample code out there? Thanks
go to post
That's great, but unfortunately, we've not upgraded to the latest and greatest. We're still using the 2015 release.