
How to creat dynaset from a dynaset in VB4 ?
Quote:
>> Use the FindFirst...FindNext...FindLast methods on the dynaset from the
>> database.
>It is more efficient to use the Filter property and then make a new dynaset
>Set dsDynasetFirst = dbDatabase.OpenRecordset("SELECT field1, field2 FROM Customers", dbOpenDynaset)
>dsDynasetFirst.Filter = "field1 = 25"
>set dsDynasetSecond = dsDynasetFirst.OpenRecordset()
If you're not using the first recordset for anything or are done
with it, it's more efficient to simply create the result in one
step:
set ds = db.OpenRecordset("SELECT _
field1, field2 FROM Customers _
WHERE field1 = 25;", dbOpenDynaset)
Cheers,
Joe
Never underestimate the power of a WAG.