|
 |
asp_databases thread: .Requery and .Filter ?
Message #1 by Jason Byrnes <byrnes@f...> on Wed, 31 Jan 2001 09:11:44 -0500
|
|
Can someone out there give an example on the uses of RecordSet.Requery and
RecordSet.Filter? is It possible to use a differnt SQL string for the
Requery? is It possible to filter DISTINCT Records? I have a database that
I'm using for drop down lists, I currently open the database using a
"SELECT DISTINCT Country FROM tblTWD Where Continent = 'North America'" to
create the list of Contrys for North America, then close the recordset and
reopen it with "SELECT DISTINCT Country FROM tblTWD WHERE Continent =
'South America'" and so on. It works but I'm sure theres got to be a better
way, Requery sounded like it would help but it keeps passing fatal
exception errors on the second SQL string and Filter keeps telling me the
property's are conflicting with one another
Jason Byrnes
Systems Administrator
Peabody Museum of Archaeology and Ethnology
11 Divinity Avenue
Cambridge, MA 02138
Phone: (xxx)xxx-xxxx
Message #2 by Imar Spaanjaars <Imar@S...> on Wed, 31 Jan 2001 15:32:09 +0100
|
|
I think you may like the following URL:
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/dasdk/ados4piv.htm
It's the ADO programmer's reference which answers all your questions, I think:
Requery:
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/dasdk/mdam22gp.htm
Filter:
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/dasdk/mdap0i7m.htm
Imar
At 09:11 AM 1/31/2001 -0500, you wrote:
>Can someone out there give an example on the uses of RecordSet.Requery and
>RecordSet.Filter? is It possible to use a differnt SQL string for the
>Requery? is It possible to filter DISTINCT Records? I have a database that
>I'm using for drop down lists, I currently open the database using a
>"SELECT DISTINCT Country FROM tblTWD Where Continent = 'North America'" to
>create the list of Contrys for North America, then close the recordset and
>reopen it with "SELECT DISTINCT Country FROM tblTWD WHERE Continent =
>'South America'" and so on. It works but I'm sure theres got to be a
>better way, Requery sounded like it would help but it keeps passing fatal
>exception errors on the second SQL string and Filter keeps telling me the
>property's are conflicting with one another
Message #3 by "Wally Burfine" <oopconsultant@h...> on Wed, 31 Jan 2001 17:02:29 -0000
|
|
Put all queries end to end then do rs.nextrecordset to step through them
>From: Jason Byrnes <byrnes@f...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] .Requery and .Filter ?
>Date: Wed, 31 Jan 2001 09:11:44 -0500
>
>Can someone out there give an example on the uses of RecordSet.Requery and
>RecordSet.Filter? is It possible to use a differnt SQL string for the
>Requery? is It possible to filter DISTINCT Records? I have a database that
>I'm using for drop down lists, I currently open the database using a
>"SELECT DISTINCT Country FROM tblTWD Where Continent = 'North America'" to
>create the list of Contrys for North America, then close the recordset and
>reopen it with "SELECT DISTINCT Country FROM tblTWD WHERE Continent
>'South America'" and so on. It works but I'm sure theres got to be a better
>way, Requery sounded like it would help but it keeps passing fatal
>exception errors on the second SQL string and Filter keeps telling me the
>property's are conflicting with one another
>
>
>Jason Byrnes
>Systems Administrator
>Peabody Museum of Archaeology and Ethnology
>11 Divinity Avenue
>Cambridge, MA 02138
>Phone: (xxx)xxx-xxxx
>
>
|
|
|
View Cart
