find in database

[Henk Salomons]

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam")

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

[Veign]

Find does not support AND / OR operators:
http://www.devguru.com/Technologies/...dset_find.html

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--

"Henk Salomons" <sa******@planet.nl> wrote in message
news:d0**********@reader11.wxs.nl...

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam")

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

[Veign]

Find does not support AND / OR operators:
http://www.devguru.com/Technologies/...dset_find.html

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--

"Henk Salomons" <sa******@planet.nl> wrote in message
news:d0**********@reader11.wxs.nl...

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam")

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

[Rob]

"Henk Salomons" <sa******@planet.nl> wrote in news:d0nlva$jgn$1
@reader11.wxs.nl:

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam")

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

Well Henk you can set a SQL string with an 'AND' operator in it:

Dim strSQL as String
strSQL = "SELECT * FROM MyTable WHERE Collum1 = 'London' AND Collum2 =
'Amsterdam'"

Once you've set the strSQL variable, the exact method of passing the
string and obtaining the data will vary according to the data object you
are using.

[Rob]

"Henk Salomons" <sa******@planet.nl> wrote in news:d0nlva$jgn$1
@reader11.wxs.nl:

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam")

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

Well Henk you can set a SQL string with an 'AND' operator in it:

Dim strSQL as String
strSQL = "SELECT * FROM MyTable WHERE Collum1 = 'London' AND Collum2 =
'Amsterdam'"

Once you've set the strSQL variable, the exact method of passing the
string and obtaining the data will vary according to the data object you
are using.

[Elef]

"Henk Salomons" <sa******@planet.nl> ha scritto nel messaggio
news:d0**********@reader11.wxs.nl...

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam"), 0,
adSearchForward, adBookmarkFirst

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

Try this (note apostrophes around town names):

Db.recordset.find("Collum1='London' AND Collum2='Amsterdam'"), 0,
adSearchForward, adBookmarkFirst

Bye
Elef

[Elef]

"Henk Salomons" <sa******@planet.nl> ha scritto nel messaggio
news:d0**********@reader11.wxs.nl...

Question,

Is it possible to use a AND in a find string, somthing like this:
Db.recordset.find("Collum1=London AND Collum2=Amsterdam"), 0,
adSearchForward, adBookmarkFirst

In this syntax is doesn't work, is there a way to do this??

Greetings Henk

Try this (note apostrophes around town names):

Db.recordset.find("Collum1='London' AND Collum2='Amsterdam'"), 0,
adSearchForward, adBookmarkFirst

Bye
Elef