|
Subject:
|
How to use seek method in DAO
|
|
Posted By:
|
nadee
|
Post Date:
|
2/20/2006 6:29:13 AM
|
|
How to set seek method in using DAO with database programming.I need to know how to set index variable and seek method.
|
|
Reply By:
|
nalla
|
Reply Date:
|
2/20/2006 10:46:53 PM
|
You don't have to create indexes and use seek method to locate a record in ADO. Just write a SQL statement as,
SELECT * FROM [table name] WHERE [field name]= '" & variable & "'
and execute it through a recordset then check whether the recordset is EOF or not. I hope this is what you wanted. please post if you need and help regarding this. It is better if you can explain the actual scenario
nalaka hewage
|
|
Reply By:
|
nadee
|
Reply Date:
|
2/21/2006 1:46:24 AM
|
I did use tht method tht u'r taking abt,but it's so slow.it takes so long to retrieve a record in end of the table.I want to have afast way to retreive data according to some specific field.
Nadee
|
|
Reply By:
|
nalla
|
Reply Date:
|
2/24/2006 2:39:17 AM
|
According to your problem creating indexes in your table is one way to improve performance. Anyway I can't agree with you that ADO is slower than DAO. It would be more helpful to you if you can explain the actual problem.
nalaka hewage
|
|
Reply By:
|
akramsab
|
Reply Date:
|
4/21/2006 10:55:37 AM
|
quote:
Originally posted by nadee
How to set seek method in using DAO with database programming.I need to know how to set index variable and seek method.
|
