Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 20th, 2006, 07:29 AM
Registered User
 
Join Date: Feb 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to use seek method in DAO

How to set seek method in using DAO with database programming.I need to know how to set index variable and seek method.
 
Old February 20th, 2006, 11:46 PM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to nalla Send a message via Yahoo to nalla
Default


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
 
Old February 21st, 2006, 02:46 AM
Registered User
 
Join Date: Feb 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old February 24th, 2006, 03:39 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to nalla Send a message via Yahoo to nalla
Default


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
 
Old April 21st, 2006, 10:55 AM
Registered User
 
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
seek a expression petergoodman XSLT 3 July 16th, 2008 01:45 AM
Seek Time... ankur_icfai SQL Server 2000 2 August 30th, 2006 11:14 PM
cannot 'seek' inside a function dextermagnific XSLT 2 August 10th, 2006 01:54 AM
DAO and seek torro17 BOOK: Access 2003 VBA Programmer's Reference 1 March 15th, 2006 06:02 PM
Seek record in Access sunny76 Access 3 February 21st, 2006 09:03 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.