Giles wrote:
"Bob Barrows [MVP]" wrote Giles wrote: How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn
Use the recordset's Filter property.
Bob Barrows
PS. Avoid Selstar: http://www.aspfaq.com/show.asp?id=2096
Thanks Bob. I do avoid * where poss since joining this NG - almost as
bad as top (or bottom) posting! However, the article seems to suggest
that if you want all fields, it is better to explicitly name the lot.
"seems to suggest"? I thought it was worded strongly enough that it would do
more than "seem to suggest" ,,, :-)
Is that right?
Yes
Does everyone do that?
Everyone who :
a) knows the pitfalls of selstar
b) is not lazy
c) wants to reduce network traffic and the time connected to the database,
resulting in better performance and resource utilization
:-)
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"