• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

URGENT: Using "Index" and "Seek" in DataEnviroment

Hello,

I use DataEnviroment to work with my Access 2000 DataBase. How can I look for records in a certain table using "Index" and "Seek"? "FindFirst" etc work very slowly. That's why I don't want to use it.

You can send me an example to my e-mail: slava_site@hotmail.com  or to publish it here.

Thanks in advance.
0
slavikn
Asked:
slavikn
1 Solution
 
baltmanCommented:
Hi slavikn,

Here is the comparison of Seek opposed to Find... methods, with sample codes. Further below are some other links to articles for you to see if you can find other options as well...
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q108149

Here's a solution for the slow functioning of FindFirst, or at least a way to work around it....
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q108380

Here's some more information on how to use Seek:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110497


Hope this helps!

BA
0
 
Ryan ChongCommented:
If the operation is not frequently use, then try to use "Where" condition in SQL rather than use FindFirst.
0
 
slaviknAuthor Commented:
Hi baltman,

All those examples do not work with DataEnviroment. Can you please give me an example for DataEnviroment.

=========================

Hi ryancys,

I will use seek a lot, that's why I need something that works very fast.

=========================

In a few hours I will get 5 points, so I will increase this question's "price" to 245!
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
slaviknAuthor Commented:
I didn't get an answer.
0
 
Asta CuCommented:
This question has never cleared, since you tried to delete it after comments have been added.  The only way to have this deleted or PAQd, is to request it in the Community Support topic area.
Asta
0
 
MindphaserCommented:
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now