All
Accepted answers
Peter Smit · Aug 8, 2025 go to post

From that query plan it looks like you don't have a index on code_1_text or the index isn't being used.
Perhaps try running a tune table.

Peter Smit · Jan 19, 2023 go to post

Using an excel python library inside objectscript (openpyxl)

This is an example from the documentation on this library

>>> wb = Workbook()
>>> ws = wb.active
>>> # set date using a Python datetime
>>> ws['A1'] = datetime.datetime(2010, 7, 21)

What i want to know is how to do the syntax on the 4th line in objectscript

Peter Smit · Jan 16, 2023 go to post

i did give it the entire csp folder.

However I've since uninstalled the reinstalled iris after which the installer successfully completed the configuration.

Peter Smit · Jan 13, 2023 go to post

I have given full permission to IIS_IUSRS for that file so not sure why it cant access it then

Peter Smit · Nov 12, 2019 go to post

If you leave everything default in the config and set httprequest.SSLConfiguration
 to whatever your config is called it should work.

This config has worked for me.

Peter Smit · Oct 15, 2019 go to post

I think 

set booksRS = ##class(%ResultSet).%New("Library.Book,BooksLoaned")

should be 

set booksRS = ##class(%ResultSet).%New("Library.Book:BooksLoaned")
 

Peter Smit · Aug 16, 2019 go to post

I've left it for nearly half an hour before and it was still going.

Peter Smit · Oct 31, 2018 go to post

Might help if you change it to

ClassMethod MyMethod(pFilePath as %String)
Peter Smit · Sep 18, 2017 go to post

I think that is the issue.

This is the line that is generating the error.

Set sc=..%BuildObjectGraph(related+2) If ('sc) ZTrap "SG"

Peter Smit · Sep 14, 2017 go to post

Maybe Java, C# or even javascript could be translated. This could allow us to reuse some existing code.

Peter Smit · Feb 16, 2017 go to post

You will either need to use a scrollable result set (%Library.ScrollableResultSet) or execute the query again.