The SQL statement works and does what it should do, but sometimes if the SQL is more complicated, Dreamweaver has trouble reading it. The fix would involve changing the SQL query to something that accomplishes the same task, but can be read by Dreamweaver. This would involve getting a new release of PowerStore out to the users.
As for my response, I wasn't sure what you were attempting to accomplish when you were double clicking on that recordset, so I offered up the solution to a common issue of displaying the value of the recordset column on the page.
The functionality of the store should be fine, however, so if you can, just work around the issue.