Zugg Software :: View topic

Magician Joined: 23 Nov 2004 Posts: 364

Open a blank session, make an alias 'find'. Connect to your database, I use a sqlite database. In alias, enter this:

$input=%trim(%lower(%-1))
row = %sql(databasename, %concat("SELECT * FROM Mobs WHERE Name LIKE","'%",$input,"%'"))
#loop 10 { #SHOW "Title: " @row.Item("Name")
#CALL @row.Next }

Then change row to a local variable, run it and you crash.

Posted: Wed Jan 27, 2010 11:48 pm

Please post questions or problems about the 3.12 BETA version to the CMUD BETA Forum. The General forum is only for the Public versions.

To answer your question, there is a known bug with using the = syntax to assign a COM variable (like the result of %sql) to variables that is causing this problem. Should be fixed in the next version.

Magician Joined: 23 Nov 2004 Posts: 364

The bug isn't with using = to assign variables, what I put up works fine as it is. The issue was if you want to use local variables it crashes. If local variables aren't meant nor ever will be designed to support a com object, then so be it. I don't know otherwise so I put it up.