searching by ADO

[Ada¶]

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

[Tom van Stiphout]

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

[Adas']

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.