By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

searching by ADO

P: n/a
Hello to everyone...
I have a problem:

In my own MS Access database, I've written a search algorythm that
checks in each table's field wether it contains value we are looking for
( sth. like: FOR I=1 To Len(Field)-Len(Value) / If
Mid(Field,I,Len(Value))=Value Then ... ). I used an ActiveX Data Objects
to access tables but results are very poor. It works terribly slow.
Maybe you know better method?
Is it possible to get faster connection with data than using ADO?

Adam

mailto:ad***@qwe.pl

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sat, 18 Oct 2003 16:56:12 GMT, Ada¶ <ad***@qwe.pl> wrote:

Use a wildcard search:
select * from MyTable
where MyField like '*abc*'

This would find all rows with the substring "abc" in the field. Check
the help file for "Like" or for "Where".

-Tom.
Hello to everyone...
I have a problem:

In my own MS Access database, I've written a search algorythm that
checks in each table's field wether it contains value we are looking for
( sth. like: FOR I=1 To Len(Field)-Len(Value) / If
Mid(Field,I,Len(Value))=Value Then ... ). I used an ActiveX Data Objects
to access tables but results are very poor. It works terribly slow.
Maybe you know better method?
Is it possible to get faster connection with data than using ADO?

Adam

mailto:ad***@qwe.pl


Nov 12 '05 #2

P: n/a
Thank you very much. It is pleasure for me to live in the world with so
intelligent people :). I didn't know that sql provides sth like this.

Adam

Tom van Stiphout wrote:
On Sat, 18 Oct 2003 16:56:12 GMT, Ada¶ <ad***@qwe.pl> wrote:

Use a wildcard search:
select * from MyTable
where MyField like '*abc*'

This would find all rows with the substring "abc" in the field. Check
the help file for "Like" or for "Where".

-Tom.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.