Visual Basic&database, ADO requery

ADO requery

Author	Message
Clyd #1 / 3	ADO requery Hi there If I already have a recordset called rs but I want to run a query on that recordset. How do we go about it using ADO ... for example in DAO I think it was: set rsNew = "select * from " & rs.name & "where Mydate = '01/01/99'" Thanks for the help Clyde Quote: >Hi there >If I already have a recordset called rs but I want to run a query on >that recordset how do we go about it ... >for example in DAO I think it was: set rsNew = "select * from " & >rs.name & "where Mydate = '01/01/99'" >Thanks for the help >Clyde
Sat, 03 Nov 2001 03:00:00 GMT

Clyd #2 / 3	ADO requery Hi there If I already have a recordset called rs but I want to run a query on that recordset how do we go about it ... for example in DAO I think it was: set rsNew = "select * from " & rs.name & "where Mydate = '01/01/99'" Thanks for the help Clyde
Sat, 03 Nov 2001 03:00:00 GMT

Derek Henderso #3 / 3	ADO requery ADO has a filter option which will allow you to filter the data in a record set. eg. rs.Filter = "Mydate='01/01/99'" hope this helps Derek Quote: >Hi there >If I already have a recordset called rs but I want to run a query on >that recordset. How do we go about it using ADO ... >for example in DAO I think it was: set rsNew = "select * from " & >rs.name & "where Mydate = '01/01/99'" >Thanks for the help >Clyde >>Hi there >>If I already have a recordset called rs but I want to run a query on >>that recordset how do we go about it ... >>for example in DAO I think it was: set rsNew = "select * from " & >>rs.name & "where Mydate = '01/01/99'" >>Thanks for the help >>Clyde
Sun, 04 Nov 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]