Applescript Error SQLGrinder got an error: NSInternalScriptE

[frankcorrigan]

I'm using SQL Grinder 2.03 to connect to a MS SQL database. In Applescript I am running this command:
execute sql with text theStatement using "connection_name" delimiter ","

If the query I use has a result I get bake the result correctly but if I run a query that does not have a result I get back an Applescript error:

"SQLGrinder got an error: NSInternalScriptError"

instead of just ""

Also, If I get the error then all other query return the same error until I restart SQLGrinder.

Is this a bug? I need to know if my query result was just empty or it really was an error.

[Lloyd]

Frank,

This is a known bug that has been around for a few versions. It would be nice to have it fixed alone with being able to use stored procedures in MS SQL in AppleScript.

In my routine, if I get that error, I automatically restart sql Grinder so that the next query gets executed.

I think there is a sample of the function I use list in the archive further down.

Lloyd

[michaeldupuis]

This should have been fixed in the latest version, which is 2.0.4. If it's still a problem, please report it to support, using the "Send Feedback" menu item in the application Help menu.