I have a class called "Names" that holds the First and Last Name and I want
to be able to export the table to a file using Cache Object Script.
Thanks,
Lyle
You need to use %SQL.Export.Mgr class
Tweak the following and try
set mx=##class(%SQL.Export.Mgr).%New()
set mx.FileName="C:\My Documents\MyNewClass.txt"
set mx.TableName="MyNewClass"
set mx.ClassName="SQLUser.MyNewClass"
set mx.HasHeaders=1
do mx.ColumnNames.Insert("FirstName")
do mx.ColumnNames.Insert("LastName")
do mx.ColumnTypes.Insert("S")
do mx.ColumnTypes.Insert("S")
set mx.Delimiter=":"
set mx.StringQuote="#"
do mx.Export(1)
do mx.CloseExport()
kill mx
Regards
Sukesh Hoogan
Bombay, India
- Enterprise Resource Planning
- Business Intelligence
- Financial Accounting
- Offshore Development
Lyle
"Sukesh Hoogan" <sukesh...@yahoo.co.in> wrote in message
news:goso7e$me7$1...@news.intersystems.com...