|
-
Oct 31st, 2000, 04:55 PM
#1
Thread Starter
Addicted Member
Which of these 2 methods is faster/more efficient for displaying a specific record from a recordset using date criteria?
(Assuming Adodc1 is pointing to "Table1")
Adodc1.RecordSource = "SELECT * FROM Table1 WHERE Date = #10/31/00#;
OR
Adodc1.Recordset.Find ("Date = #10/31/00#"), 0, adSearchForward, 1
?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|