I think something is going wrong with the compile detetecting if the
thing needs compiling
check Tools | Option | Class
see if you have "do not compile upto date classes"
and "compile dependent classes"
have no tick in the first and a tick in the second
If the dates/times are different between systems the compiler thinks
there is no need to compile it
changing some text (to MySQL) makes it compile
also
the Dynamic SQL parser looks at previously compiled queries to work
out if it needs to re-compile
this can also get out of sync
in SQL manager delete compiled queries
or
do $System.SQL.Purge()
from the command line
HTH
Peter
On Tue, 25 May 2004 16:31:25 +0200, "Rogier Schouten"
<[EMAIL PROTECTED]> wrote:
>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,
