Warm tip: This article is reproduced from stackoverflow.com, please click
vb6 adodb recordset

ADO Recordset filter comparing two fields

发布于 2020-04-08 23:39:48

How can I filter a recordset by comparing two fields?

For a given ADO Recordset with n fields (Field1, Field2,...,Fieldn)

I used to filter a field against a value:

rs.Filter = "Field1 = 'something'"

But what I need to do is something like this:

rs.Filter = "Field1 = Field2"

Is that possible?

Questioner
Yoa
Viewed
17
分享
Bob77 2020-02-07 06:09

The criteria string is made up of clauses in the form FieldName-Operator-Value

Value is the value with which you will compare the field values (for example, 'Smith', #8/24/95#, 12.345, or $50.00). Use single quotes with strings and pound signs (#) with dates. For numbers, you can use decimal points, dollar signs, and scientific notation. If Operator is LIKE, Value can use wildcards. Only the asterisk (*) and percent sign (%) wild cards are allowed, and they must be the last character in the string. Value cannot be null.

This suggests that comparing fields to each other is not supported. Value must be a literal.

Yoa 2020-02-08 02:08:34

Thank you!!!!!!

Related issues

1
Write text file in appending (utf-8 encoded) in VB6
2
Access Vb6 query
3
Equivalent of Directory.CreateDirectory() in VB6
4
Visual Basic 6 causes Visual Studio 2010 to attempt an installation
5
FloodFill using c-sharp
6
Intellisense not working in visual studio 6?
7
Altering togglebutton state based on other togglebutton state
8
Problems with FM20.dll and crystl32.ocx while opening VB6 project
9
How capitalize fullname in vb6
10
PV Function and Porting VB6 to C#