Hey All,

Ok so having a weird problem. I'm using dw8 and have created recordsets on a page that work fine with no problems, But i need to change on of the recordsets but dw is not showing the recordset in the application window. yet the code for the rs still appears on the page.

I've tried double clicking a dynamic item in the application list and it says that they rs cannot be found.

Does anyone know why this has happened? And how i can fix it?

If it help i did have to reinstall dw8 as a extension mucked it up for some reason.

Thanks in advance

Tom

Hi,
I had similar problem . I hope this link helps you.
dmxzone.com/forum/topic.asp?topic_id=38308

If you have to get current recordset displayed when you test ,
SELECT *
FROM Test
WHERE PrId in (select MAX(PrId) from Test)

change the above sample according to your need and paste the above code in sql window.
PrId : auto id that I created for each record. So the recordset displays PrId thats entered last.

Hiran.