ADO and SQL Server troubles

[jdavidi]

Howdy!

Loving v7; was attempting to utilize ADO actions for the first time in concert with the new Loop action. My query is going against a SQL Server (2000) database.

ADO query is Select ReleaseID from Release

The loop action type is ADO Recordset, and I provided %ADO_RS% as the macro.

The query seems to work, as LOOP_COUNT is equal to what I expect, however I can't seem to retrive any of the values.

In the substep of the loop, I tried a simple run script action using the syntax from the Server.bld sample file to try to MsgBox [vbld_TempMacroObj("LOOP_VALUE").Fields("ReleaseID" ).Value]
but it returns empty.

The sample.bld works fine with the Access database, but is the syntax for data retrival different with a SQL Server provider?

Thanks!

--jdavidi