I imported the data and the forms that referenced that query stopped working.
I opened the Class containing the query, recompiled the Class and got the same error.
I cutted the query with Ctrl-X, recompiled the class, Pasted the query again, recompiled and YES !! It's working again !
Nuno
Rogier Schouten wrote:
Correction:
Changing the variable name was not the solution. The following is:
Go to the terminal. Type:
Set result = ##class(%Library.ResultSet).%New() Do result.Prepare("SELECT bla FROM table") Do result.Execute() Write Result.Next()
Now execute the MAC routine and it works...what is going on here?
Yours, Rogier
"Rogier Schouten" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Hi,
I found a strange bug:
I have a class containing a method like this:
Method MyMethod(){ Set SQL = "SELECT bla FROM table" Set result = ##class(%Library.ResultSet).%New() Do result.Prepare(SQL) Do result.Execute()
... etc etc }
When I call this method from a MAC routine, everything works. Now when I export the project to an XML file, import it into another namespace, and call the MAC routine again, the method fails with error:
<NOROUTINE>zSQLExecute+2^%ooLibrary.DynamicQuery.1
After a long time, I tried changing the variable name SQL into MySQL, and hey presto, it works!
How is this possible? I'm very curious because I would like to prevent
these
kind of errors in the future.
Regards, -- Rogier Schouten
Developer Technische Universiteit Eindhoven Bibliotheekautomatisering De Hal 1.16 Postbus 90159 5600MB Eindhoven Phone +31402473907 E-mail [EMAIL PROTECTED]
